Clear All Checkboxes in a Microsoft Access Continuous Form
Question details
Clear all checkboxes bound to a Yes/No field in an Access continuous form.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A continuous form displays checklist records with a bound Verified checkbox and a Clear All button.
- Observed behavior
- Changing a checkbox control directly may affect only the current record, while setting the Yes/No field to Null does not reliably clear it.
Confirm the table and Yes/No field names in the form's record source, and ensure you have permission to update the records. Decide whether to clear every table row or only a specific subset before running the query.
Update the bound Yes/No field with a Clear All button
Use an UPDATE query to set the checkbox field to False across the table, then requery the form.
In a continuous form, the checkbox represents a field value in each record. Updating the underlying field clears the stored values rather than changing only the current checkbox instance.
Open the form in Design View, select the Clear All button, and use Property Sheet > Event > On Click to create or open an Event Procedure.
In the button's Click procedure, add: If Me.Dirty Then Me.Dirty = False, followed by CurrentDb.Execute "UPDATE [YourTableName] SET [Verified] = FALSE", dbFailOnError. Replace the table and field names with your own.
Add Me.Requery after the Execute statement, save the form, and click Clear All in Form View to confirm that the checkboxes are cleared.

Manage spreadsheet checklists with WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for working with spreadsheets and other documents. Export Access data to Excel if you want to continue managing a checklist in WPS Spreadsheets; WPS does not repair or run Access forms.

Frequently Asked Questions
Why should I set the Yes/No field to False instead of Null?
False represents an unchecked Yes/No value. In the UPDATE query, use SET [Verified] = FALSE rather than SET [Verified] = NULL.
Will this clear only the records visible in the form?
No. An UPDATE query without a WHERE clause affects every row in the named table, regardless of the form's current filter. Add a WHERE clause to restrict the affected records.
Why save the current record before running the query?
Saving with If Me.Dirty Then Me.Dirty = False commits any pending edits on the current form record before the table is updated.
How do I show the cleared values after the update?
Run Me.Requery after CurrentDb.Execute in the button's Click procedure to reload the form's records and display their updated values.
Can WPS Office run my Access continuous form?
No. WPS Office does not run Access forms. You can export Access data to an Excel file and open it in WPS Spreadsheets to work with the data as a spreadsheet.




