O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

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

Find and Replace

The best method for locating and editing a few values is often the Find and Replace dialog box, available from the Edit menu in a datasheet or form (see Figure 7.1). On the Find tab, you enter criteria in the Find What box, adjust the other settings in the dialog box, and click Find Next. Access continues to find values that meet the criteria you entered, until you get a message that it couldn't find any matches. The Replace tab works similarly, but it also offers the capability to edit data.

Figure 7.1. The Find and Replace dialog box.

You've probably been using Find dialog boxes in Microsoft Office for ...

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