Using Find and Replace


Using the Find feature is an easy way to find a record that contains specific information. You can also use Find and Replace to change data automatically throughout a table. The Find and Replace commands are part of the same dialog box. You can use the tabs at the top of the dialog to move back and forth between Find and Replace.



To use Find and Replace:

  1. To find a record(s) that contains specific information, press + to invoke the Find command.
  2. Type the text that you want to search for in the Find What: box.
  3. Click Find Next to go to the first record that matches your find criteria.
  4. To replace text, click the Replace tab.
  5. Type the text you want to find in the Find What: box; type the text you want to replace it with in the Replace With: box.
  6. Click the Replace All button.


To narrow your Find and Replace parameters, you can also:
  1. Use the Search In: list to specify whether to match the text to data in a specifc field or to any field in the table.
  2. Use the Match: list to specify what part of the field must match your text.
  3. Use the Search: list to search only up or down from the current record.
  4. Use the Match Case check box to find only records that match the case of your find text.

If you don't want to replace text in all records, use the Replace button (instead of Replace All) to find and replace only the first record that matches your find criteria.

The Find and Replace commands are part of the same dialog box. You can use the tabs at the top of the dialog to move back and forth between Find and Replace.

You can invoke the Find command by:

  1. Use the keyboard shortcut + .
  2. Select Find from the Edit menu.
  3. Click the Find toolbar button.

You can invoke the Replace command by:

  1. Use the keyboard shortcut + .
  2. Select Replace from the Edit menu.