Tick all Boxes

[News]

I have a database that I have imported from other sources. One of the
columns I have created has a data type Yes/No with a tick box (I am in
datasheet view of a table). Is there an easy way to tick every box other
then ticking on each individual one. (I have 2418 records)


Thanks

 

[Allen Browne]

Use an Update row to set the yes/no field to Yes for all records:

1. Create a query using this table.

2. Change it to an Update query (Update on Query menu.)
Access adds an Update row to the grid.

3. Drag the yes/no field into the grid.
In the Update row under this field, enter:
True

4. Run the query.