How to create a checkbox datatype column in a table in VB .net code
- From: evan1979.2@xxxxxxxxx
- Date: Thu, 1 May 2008 04:02:14 -0700 (PDT)
I am creating a new boolean column in a MSAccess .mdb database like
this:
Dim Cmd As New OleDb.OleDbCommand("ALTER TABLE m_table ADD boolColumn
YesNo", objConn)
Cmd.ExecuteNonQuery()
, which works fine. But... when the .mdb file is opened in Access the
values for the new column are shown as "-1" and "0"...
Is there a way to make the column display in Access as checkboxes? I
want to be able to do this at runtime in my .net program.
thanks.
.
- Follow-Ups:
- Re: How to create a checkbox datatype column in a table in VB .net code
- From: Bob Barrows [MVP]
- Re: How to create a checkbox datatype column in a table in VB .net code
- Next by Date: Reading text files with UTF-8 byte order mark
- Next by thread: Re: How to create a checkbox datatype column in a table in VB .net code
- Index(es):