Others

Set a Checkbox Default Value to Zero in Microsoft Access

Khadija KhanKhadija Khan Nov 20, 2026 868 views

Question details

Set an Access form checkbox to False by default so a query can use a consistent criterion.

Set a Checkbox Default Value to Zero in Microsoft Access
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.
Before you start

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.

Solution 1Recommended

Set the Access checkbox Default Value to 0

Use this for an unbound checkbox or to give new records a False checkbox value.

1
Open the form in Design View

In the Navigation Pane, right-click the form and select Design View.

2
Select the checkbox

Click the checkbox used by the query, then open the Property Sheet if it is not already visible.

3
Set the default

On the Data tab of the Property Sheet, set Default Value to 0.

4
Save and test

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.

Set the Access checkbox Default Value to 0
Existing records: Changing Default Value does not replace Null values already stored in existing records. Use Nz in the query if those values need to be treated as False.
Free Microsoft Office alternative

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.

Use a familiar interface for documents, spreadsheets, and presentationsOpen and edit Microsoft Office formats such as DOCX, XLSX, and PPTXWork with spreadsheet data in WPS Spreadsheets alongside your Access workflowUse a free, lightweight office suite for everyday tasks
QA img-9

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.