Home > Articles > Data > Access

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Replacing Data

1Click anywhere in the field, or column, that contains the entries you want to replace.

2Open the Edit menu and choose Replace.

3The Find and Replace dialog box opens with the Replace tab displayed. In the Find What field, type the entry you want to find.

4In the Replace With field, type the entry to use as the replacement.

5After you've made any necessary changes to the search options, click the Find Next button. (To learn more about the various search options, see the preceding task.)

6Access locates and selects the record with the first matching entry. To replace it, click the Replace button.

7The replacement is made. Access moves to the next match; continue making replacements as needed.

8Access notifies you when no more matches are found. Click OK.

  • + Share This
  • 🔖 Save To Your Account