Find blank fields or zero-length strings using the Find dialog box

1. In Form or Datasheet view, click in the field (column) you want to search, and then click Find on the toolbar.
   
   
2. Click More, if necessary.
   
   
3. Do one of the following:
   • If blank fields are formatted (such as "Unknown"), type the formatted string, and make sure that the Search Fields As Formatted check box is selected. To find unformatted blank fields in a Microsoft Access database, in the Find What box, type Null or Is Null, and make sure that the Search Fields As Formatted check box is not selected.
     
     
   • To find zero-length strings, in the Find What box, type double quotation marks (""), with no spaces in between, and make sure that the Search Fields As Formatted check box is not selected.
4. In the Search box, select Up or Down.
   
   
5. In the Match box, make sure that Whole Field is selected.
   
   
6. In the Look In box, select the field to search.
   
   
7. To find one or more occurrences of a blank, click Find Next.