"Find" Default - "Match - Any Part of Field"

[Guest]

The default "Find - Match" (in the Edit menu item) is "Whole Field".

Is it possible to make the default "Any Part of Field"? I'd like Access to
default to "Any Part of Field" whenever some one uses the "Find" command in
the Edit menu. If it is possible how does one change the default?

Thank you.
Mark

 

['69 Camaro]

Hi, Mark.

Select the Tools -> Options menu to open the "Options" dialog window.
Select the "Edit/Find" tab. Select the "General Search" option button at
the top left of the window, then the "OK" button to close the window.
Access will continue to use your current setting that you've already
manually applied in the "Find And Replace" window (whether it's "Any Part of
Field," "Whole Field," or "Start of Field") for any future search during
your current session. That's why the new setting doesn't appear to "stick."
However, the next time you open the database in Access, it will use your new
default "Any Part of Field" for searches, so you won't have to apply it
manually again.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.