Using the Find feature in Access has probably become so second nature that you speedily enter your criteria and click Find First the moment the dialog box appears - only to frustrate yourself when your search doesn't turn up any hits because you forgot to change the search options. If you find yourself frequently changing  Access's default Find options, you can change the defaults it uses to something more akin to your personal search preferences. To do so, select Tools/Options from the menu bar. Then, click on the Edit/Find tab and select the option button you want from the Default Find/Replace Behavior panel. Fast Search is the default, and causes Access to search the current field for an exact match to your

criteria. The next option, General Search, searches all fields and matches any part of the field. The final option, Start Of Field Search, searches the current field for matches between your search string and the beginning characters in the field. When you've made your selection, click OK. Note that you may have to restart Access before the changes take effect.

Access Index

Main Index