Alter Table, YES/NO field

[gmaster]

Hi! I created a query that adds a Yes/No field to a table, but when i open that table this new field doesn't show up with checkboxes but with zeroes....Why? Is there a way to create it with checkboxes via SQL?

ALTER TABLE Table_1 ADD COLUMN Check YESNO;

[June7]

Why do you need to use code to alter a table to add a field?

I don't think SQL can do that. Maybe requires VBA code to modify TableDef. The field was created with the Lookup Display Control property set as textbox.