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

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

Replacing Matched Field Values Automatically

The Find and Replace dialog's Replace page lets you replace values selectively in fields that match the entry in the Find What text box. To open the dialog with the Replace page active, choose Edit, Replace or press Ctrl+H. Why the shortcut key combination for the Edit menu's Replace command is Ctrl+H remains a mystery.

The entries to search for Luleå and replace with Lulea appear in Figure 7.8. If you performed the search in the preceding section, select Customers:Table from the Look In drop-down list, 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. Unlike Word and Excel, you can't undo search and replace operations in Jet (or SQL Server) tables. Before making replacements, a message box opens to request that you confirm the pending changes.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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