Changing MSAccess "Find" options

  • Thread starter Thread starter John Baker
  • Start date Start date
J

John Baker

I have an Access97 database and have a button on the form to open the
MSAccess Find dialog form.
I use the following code:

DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Is there any way in which I can have the Find dialog open with the "Match"
cbo box open with "Any Part of Field" rather than the default of "Whole
Field"

Any help greatly appreciated

John B.
 
Hi John.

Try setting:
Tools | Options | Edit/Find | Default Find/Replace Behavior

To set it programmatically:
SetOption("Default Find/Replace Behavior",2)
 
Back
Top