Set a Checkbox Default Value to Zero in Microsoft Access
Question details
Set an Access form checkbox to False by default so a query can use a consistent criterion.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A query uses a checkbox on an Access form as a criterion.
- Observed behavior
- The query works only after the checkbox is changed; the checkbox may initially contain Null instead of False or 0.
Identify the form and checkbox used by the query, and check whether the checkbox is bound to a field. A default value applies to new records, not to existing bound field values.
Set the Access checkbox Default Value to 0
Use this for an unbound checkbox or to give new records a False checkbox value.
In the Navigation Pane, right-click the form and select Design View.
Click the checkbox used by the query, then open the Property Sheet if it is not already visible.
On the Data tab of the Property Sheet, set Default Value to 0.
Save the form, close it, and reopen it. Run the query without changing the checkbox; if the checkbox is bound, test with a new record.

Treat a Null checkbox value as False in the query
Use this when the checkbox can still contain Null, such as when it is bound to an existing record.
Work with Office documents and spreadsheets in WPS Office
WPS Office is a free, lightweight alternative for everyday document and spreadsheet work. Its familiar interface and Microsoft Office format support make it easy to move existing files, but it does not fix Access forms or queries.

Frequently Asked Questions
What value represents False in an Access checkbox?
False is represented by 0. In the checkbox Property Sheet, set Default Value to 0 to initialize an unbound checkbox or a checkbox on a new record as False.
Why is my checkbox still Null after I set its default?
A Default Value does not change values already stored in existing records. If the checkbox is bound to a field containing Null, use Nz in the query to treat that value as 0.
How can a query read a checkbox on a form?
In the query's Criteria row, reference the control as [Forms]![FormName]![CheckBoxName], using your actual form and checkbox names. Keep the form open when you run the query.
Does Nz change the value stored in the table?
No. Nz([Forms]![FormName]![CheckBoxName], 0) returns 0 to the query when the control is Null; it does not update the stored field.




