It's your choice
Using Find in Access can be frustrating when you forget to change the search options.
You can change the defaults to something closer to your personal search preferences.
To do so, select Tools>Options from the menu bar (the Office Logo in 2007).
Then, click on the Edit>Find tab (under Advanced in 2007) and select the option button you want from Default Find>Replace Behavior.
- Fast Search is the default, and causes Access to search the current field for an exact match to your criteria.
- General Search, searches all fields and matches any part of the field.
- Start Of Field Search, searches the current field for matches between your search string and the beginning characters in the field.
See all Topics