aceditmenu option to match any part of the field

R

Rli

The line
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
brings up the find dialog.
How can I automatically set the option Match 'Any part of field' withoud
clicking on it? (The default value is 'Whole field')
Can anyone help me?
 
A

Allen Browne

Go to:
Tools | Options | Edit/Find
and try setting:
Default find/replace behavior
to:
General search
 
R

Rli

Thanks Allen,
that did influence the behaviour of the default find dialog.
Just one 'but': each time when i start up my mdb and i click first on a form
field and then on 'find' the find dialog comes up with 'Any part of field'
(that's what i want) but now also with another 'Look in' field (not the one i
clicked on in the beginning....). So i must still correct first....
The next time i click on find ist behaviour is ok....odd?
 
A

Allen Browne

Yes, sounds odd.

I don't use that dialog, so have not seen this behavior.
What version of Access and service pack is this? (Help | About)
 
Top