Searches for specified text or numeric value in the currently loaded Data View table.
Access Methods
Data View 
Replace (This menu is available only if you have a database table open in the Data View window.)
Right-click a single cell or column header in the Data View window and choose Replace
You can specify a replacement value that overwrites the value that you're searching for. The search is limited to a single database table column. It is not possible to conduct a global search that scans all columns in the database table. You can open this dialog box using the following methods:
List of Options
The following options are displayed.
- Find What
-
Specifies the value to search for.
- Replace With
-
Specifies a replacement value for the value that you're searching for.
- Match Case
-
Searches for the exact value, including case, of what you enter in Find What. If this option is cleared, the program searches for the value regardless of case.
- Find Next
-
Finds the next occurrence of the value that you're searching for.
- Replace
-
Replaces the next occurrence of the value that you're searching for with the value specified in Replace With.
- Replace All
-
Replaces all occurrences of the value that you're searching for with the value specified in Replace With.