change default state of check box

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

Guest

When I open Access, I would like my table to begin with all the check boxes
marked then have my staff "uncheck" the boxes as needed. What is the easiest
way to change the default setting so the boxes are all checked? It is an
Access 2000 file.
 
You can simply set the default value of any checkboxes on a form by opening
the form in design view and right clicking the box to open the properties
box, then go to data and enter 1 in the default value.

Slightly confused about you wanting all the boxes in a table to be checked
on opening. You could use the OnClose function for this. But if your staff
make changes such as unchecking a box dont you want to save these changes.
You can reset the table each time the form or table is opened or close but
cant really see why you would want this.

Hope this helps


Wayne

If you feel this answer has been useful please check the "was this post
helpful".
 
Open the table in design view.
Set the default value for each of the check box field to true. The check box
for each new record will be set to checked.
 
Back
Top