• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Sorting, Finding, and Filteri... > Replacing Matched Field Values Autom...

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 records by clicking the Replace All button.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint