Find specific occurrences of a value in a field

For information on finding Null values and zero-length strings, click .

1. In Form or Datasheet view, select the field (column) you want to search, unless you want to search all fields. (Searching a single field is faster than searching the entire form or datasheet.)
   
   
2. Click Find on the toolbar.
   
   
3. In the Find What box, type the value you want to find.

   If you don't know the exact value you want to find, you can use wildcard characters in the Find What box to specify what you're looking for. For examples of wildcard characters and how to use them, click .

4. Set any other options you want to use in the Find dialog box. Click More for additional options.
   
   
5. Click Find Next.

Notes

• When looking for values in a datasheet with a subdatasheet, or form with a subform displayed as a datasheet, Microsoft Access only looks in the datasheet, subdatasheet, or form where you’ve placed the insertion point.
  
  
• In the Code window, the Find dialog box has additional options specific to the Visual Basic Editor. You can specify the range of the search by selecting an option in the Search options group. Note that Access searches procedures based on the order they were added to the module. The Use Pattern Matching check box uses the same semantics as the Like Operator uses.