Checkbox column in a table

[Cormalado]

Hi Everyone,

I am a newbie in MS Access. I want to write a query for altering a table
such that
the new column added should be of type checkbox (which can be done by the
design by going to Lookup tab in the design form).

So when I open up the table that particular column should be like all filled
with checkboxes. (By Default it will be Textboxes).
And also how to give a default value to the checkbox ?

Please help me out... !

 

[John W. Vinson]

Hi Everyone,

I am a newbie in MS Access. I want to write a query for altering a table
such that
the new column added should be of type checkbox (which can be done by the
design by going to Lookup tab in the design form).

So when I open up the table that particular column should be like all filled
with checkboxes. (By Default it will be Textboxes).
And also how to give a default value to the checkbox ?

Please help me out... !

Tables are designed for data *storage*, not for data editing or data
presentation. As a rule, users should never even *see* a table datasheet!
Given that, it makes no difference whether the table Yes/No field is displayed
(in the table datasheet) as a checkbox, a combo box, or a textbox.

The user should be interacting with the data using a Form - on which you can
bind any of these control types to the yes/no field.

John W. Vinson [MVP]