Special Edition Using Access 97, Second Edition

Replacing Matched Field Values Automatically

A variation on the Find in Field dialog's theme—the Replace in Field dialog—enables you to replace values selectively in fields that match the entry in the Find What text box. To display the Replace in Field dialog, choose Edit, Replace, or press Ctrl+H. (No button on the standard Table Datasheet toolbar exists for the search-and-replace feature.) The derivation of the shortcut key combination for Edit, Re place—Ctrl+H—is a mystery.

The entries to search for Luleå and replace with Lulea appear in Figure 6.8. To replace entries selectively, click the Find Next button, and then click the Replace button for those records in which you want to replace the value. You can do a bulk replace in all matching ...