ALTER Table Add Column...y/n?

[nycdon]

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"

 

[Peter Hibbs]

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

Peter Hibbs.