About finding or replacing data

Ways to find or replace data

There are many ways in Microsoft Access to find or replace just the data you need, whether you're looking for a particular value, one record, or a group of records.

• You can find a record by scrolling in a datasheet or form, or by typing its record number in the record number box.
  
  
• With the Find dialog box, you can locate specific records or find certain values within fields. You can navigate through records as Access finds each occurrence of the item you're looking for. If you want to replace certain values that you find, use the Replace dialog box instead.
  
  
• With a filter, you can temporarily isolate and view a specific set of records to work with while you have a form or datasheet displayed.
  
  
• With a query, you can work with a specific set of records that meet criteria you specify from one or more tables in the database. You can work with this subset independent of a specific form or datasheet by running the query.

The effect of the maximum record limit in a Microsoft Access project

When you attempt to find or replace data in a Microsoft Access project, Access performs the operation only on the data that is stored on the client. If your datasheet or form has reached its maximum record limit, there is more data on the server. To ensure that you are finding or replacing all the data on the server, set the maximum record limit to no limit by using the maximum record limit button to the right of the navigation buttons.