How do I check a whole column of checkboxes in a table?

J

jcoffiel

In an access table, if I have created a column of checkboxes, and now need to
check them all. How do I do that. There are about 8000 boxes in the table and
I don't want to check one by one.
 
V

Vladimír Cvajniga

1) Create a new query.
2) Go to SQL view.
3) Put the (similar) code:
UPDATE myTable SET myTable.myCheckBox = TRUE
4) Run the query.

HTH

Vlado
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top