ALTER Table Add Column...y/n?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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"
Click to expand...

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.
 
Back
Top