Using the Null Keyword

You can use the null keyword to search for records that contain blank fields with null values. In form fields, a null value appears as an empty field in which no value has been specified.

You can use the null keyword in these areas of the application:

Filter-in-Place mode
Query form searches
Saved filters

The null keyword cannot be used for searches of field values in a collection (Edit > Find Value in Collection).

To do a null keyword search:

In Filter-in-Place mode, specify null in any field in which you can type characters.
In query forms, you can use the null keyword in any of the primary criteria or additional criteria fields that use the = (equal) or <> (not equal) operator.

Note:

To find records where a particular field is not blank (null), specify <>null
The null keyword is not case-sensitive.
To perform a search in which a field might contain, in whole or in part, the word "null," enclose it in asterisks (*null*).