Home
>
Articles
>
Data
>
Access
This chapter is from the book
Replacing Data
-
Click anywhere in the field, or column, that contains the entries you want to replace.
-
Open the Edit menu and choose Replace.
-
The Find and Replace dialog box opens with the Replace tab displayed. In the Find What field, type the entry you want to find.
-
In the Replace With field, type the entry to use as the replacement.
-
-
After 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.)
-
Access locates and selects the record with the first matching entry. To replace it, click the Replace button.
-
The replacement is made. Access moves to the next match; continue making replacements as needed.
-
Access notifies you when no more matches are found. Click OK.