Changing MSAccess "Find" options

[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.

 

[Allen Browne]

Hi John.

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

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