how do I add y/n column in A2003 with ddl/vba? I tried datatype of BIT, but
shows as 0/-1, whereas other y/n columns defined in designer show as checkbox
(datasheet view) . Would like to have these look same..

db.Execute "ALTER TABLE [Expense] ADD COLUMN [Reviewed] BIT"

Have a look at
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE%20Update%20Utility.mdb'
which may help.

Peter Hibbs.

On Tue, 10 Jul 2007 11:18:01 -0700, nycdon
<(E-Mail Removed)> wrote:

>
>how do I add y/n column in A2003 with ddl/vba? I tried datatype of BIT, but
>shows as 0/-1, whereas other y/n columns defined in designer show as checkbox
>(datasheet view) . Would like to have these look same..
>
>db.Execute "ALTER TABLE [Expense] ADD COLUMN [Reviewed] BIT"

"nycdon" <(E-Mail Removed)> wrote in message
news:1A4FA203-6E78-48C6-859B-(E-Mail Removed)...
>
> how do I add y/n column in A2003 with ddl/vba? I tried datatype of BIT, but
> shows as 0/-1, whereas other y/n columns defined in designer show as checkbox
> (datasheet view) . Would like to have these look same..
>
> db.Execute "ALTER TABLE [Expense] ADD COLUMN [Reviewed] BIT"

nycdon,

It is doing exactly what it should be doing. All BIT datatype columns store 0 or -1.

When you use a datasheet view of a table, it may have been set to show Yes/No, or a
check-box, but that is not the information that is being stored.

You may need to go into your table in Design View, select the column name's row, look down
to the General Tab, and in the Format field write in "Yes/No". Switch to the Lookup Tab
and make sure Display Control is set to Text Box.


Sincerely,

Chris O.