Datasheet Filter in Access 2016 to only show records with blanks in a field.
Posted on 2016-07-15
In Access 2016, if you're in datasheet view of a form and the number of records read is too much to show a list of values to filter on for a field, not only do the values to filter on not appear but also the "blanks" checkbox does not appear as a filter option. In this circumstance, how can a user EASILY set a filter to show only records with blanks for that field without having to type an expression like "([Addresses].[POBox] Is Null OR [Addresses].[POBox]="") in the filter by form? I need to make this easy for the user. Also, I don't want to increase the option value for "Don't display lists when more than this number of records is read" because there are over 40,000 records.