Others

How to Use True or False Criteria for Access Checkbox Fields

Maira Mehtab Oct 14, 2026 869 views

Question details

The user needs to correctly filter records using Yes/No (Boolean) checkbox fields in a Microsoft Access query without getting unexpected results.

How to Correctly Use True or False Criteria for Access Checkbox Fields

Product: Microsoft Access
Device & OS: not provided
Scenario: Filtering query results based on a Boolean (Yes/No) field in a Microsoft Access database.
Observed behavior: Queries return unexpected or incorrect records because Boolean criteria are entered with quotation marks, forcing Access to treat them as text instead of logical values.

Before you start

Open your Microsoft Access database and navigate to the query you want to modify in Design View.

Solution 1Recommended

Use Proper Boolean Constants for Yes/No Fields

Ensure you are using standard Boolean values without quotation marks so Access recognizes them as logical criteria rather than text strings.

Microsoft Access stores Yes/No fields as numerical Boolean values (-1 for True, 0 for False). Enclosing criteria in quotation marks tells Access to look for a text string, which will fail to match the underlying numerical data.

Open Query Design

Open your query in Design View by right-clicking the query in the Navigation Pane and selecting 'Design View'.

Locate the Criteria Row

Find the column containing your Yes/No (checkbox) field in the query design grid.

Enter Boolean Criteria

In the 'Criteria' row, type True to find checked records or False to find unchecked records. Make sure you do not type quotation marks around these words.

Use Numerical Equivalents (Optional)

Alternatively, you can type -1 to search for True values, or type 0 to search for False values.

Run the Query

Click the 'Run' button (the red exclamation mark) in the Query Design ribbon to verify that the query now returns the correct records.

Use Proper Boolean Constants for Yes/No Fields

Three-State Checkboxes: If your Yes/No field is configured as a three-state field, it may also contain Null values indicating an undetermined state. You can type 'Is Null' in the Criteria row to find these specific records.

Solution 2

Check Query Criteria in SQL View

Reviewing the raw SQL code can help you spot hidden quotation marks or syntax errors causing the query to fail.

Free Microsoft Office alternative

Looking for a Lightweight Alternative for Your Daily Office Tasks?

While Microsoft Access is a specialized database management tool, most daily document, spreadsheet, and presentation tasks can be handled seamlessly with WPS Office. It is highly compatible with Microsoft formats, completely free for basic use, and uses minimal system resources.

1. Visit the WPS Office Website: Navigate to the official WPS Office website using your web browser.
2. Download the Installer: Click the 'Free Download' button to download the correct version for your operating system.
3. Install the Software: Run the downloaded installer and follow the on-screen instructions to complete the setup.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight design ensures fast startup and smooth operation on any device.Familiar user interface requires no learning curve to get started.Built-in PDF editor for creating, editing, and converting PDF documents easily.

microsoft office alternative - wps office

Frequently Asked Questions

Why does typing False in my Access query return zero results?

If you type "False" with quotation marks, Access looks for a text string containing the word 'False' instead of recognizing it as a logical Boolean value. Because Yes/No fields store data as -1 or 0, the text search finds no matches. Always remove the quotation marks.

What numerical values correspond to True and False in Microsoft Access?

In Microsoft Access databases, a selected or checked (True) Yes/No field stores the numerical value -1, while an unselected or unchecked (False) field stores the numerical value 0.

Can an Access Yes/No checkbox field be completely empty?

Standard Yes/No fields only hold True (-1) or False (0). However, if the field's properties are configured to allow it to function as a three-state checkbox, it can also contain a Null value to represent an undetermined or missing state.

Office Quick Solutions