- Opening and Closing a Table in Datasheet View
- Entering Data in a Table
- Displaying Records
- Creating a New Record
- Selecting an Entry
- Selecting Records and Columns
- Freezing and Unfreezing Columns
- Hiding and Unhiding Columns
- Resizing Columns
- Rearranging Columns
- Editing a Record
- Deleting a Record
- Copying an Entry
- Copying an Entire Record
- Sorting Records in Datasheet View
- Finding Data
- Replacing Data
- Formatting the Datasheet
- Changing the Font
- Checking Spelling
- Previewing and Printing a Table
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.