O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using the Replace Feature

Replacing is a lot like finding; it finds the specified text. But as an extra bonus, it replaces the found text with text that you specify. For instance, if you found that you misspelled a brand name in your inventory you could replace the word with the correct spelling. Or, in our dog kennel example, you could find the dog named Sheldon and change his name to Sherman, if his new owners changed his name.

To find and replace data, follow these steps:

  1. Select Edit, Replace or press Ctrl+H. The Replace dialog box appears (see figure 17.3).

  2. Type the text you want to find in the Find What text box.

  3. Type the text you want to replace it with in the Replace With text box.

  4. Select any options you want, as you learned to do with ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required