Replace Dialog Box (Data View Window)

Access Methods

DBCONNECT (Command)

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.