Clearing all check boxes in a column at once

  • Thread starter Thread starter Mike Hartnagel
  • Start date Start date
M

Mike Hartnagel

I need to maintain a Little League data base where boxes
are checked as we receive registrations for the season.
To use the database for the next season we need to clear
all the boxes. Any easy way to do this? I'm a relative
neophyte.
thanks for any help.
Mike
 
Mike

What is it that your table holds rows of, that you need to un-check all the
rows? There might be another approach...

Good luck

Jeff Boyce
<Access MVP>

P.S. look into Access HELP on an "update query".
 
To use the database for the next season we need to clear
all the boxes. Any easy way to do this?
Click to expand...

UPDATE MyTable
SET MyField = FALSE

or, in the GUI:-
start a new query and add the one table;
change the type to UPDATE QUERY;
add the one field you want to update;
enter FALSE into the UpdateTo row; and
run it by clicking the red ! mark.

HTH

Tim F
 
Back
Top