Checkbox column in a table

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

Guest

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... !
 
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... !
Click to expand...

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