Find-Replace - the default "Match" parameter to "Any Part of Field

K

Keith

On a form I have added (via wizard) a command button that opens the "Find"
dialog box. I modified the code to set the focus on a default form object
(the "Name" field) that is the subject of the search so the user doesn't have
to. The default search parameter is "Whole Field", which I want to change to
"Any Part of Field" while keeping the "Look in" defaulted to the setfocus
"Name" field. I have tinkered with the "Tools", "Options", "Edit-Find",
"Default Edit-Find Behaviors" settings unsuccessfully. It has occurred to me
there is probably an "ac" setting that might accomplish this in the line of
code generated by the wizard:

DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

...but I find "Help" in Access generally less than helpful, particularly when
it comes to "DO" commands.

Any suggestions?

Thanks

Keith Bissonnette
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Manipulate Find Replace Dialog Box using Code 3
Default Position for Find & Replace Feature 3
How do I change the default Match list in Find and Replace box? 2
Make Searches Match Any Part of Field 2
Duplicate existing records - with a change 11
How Do I Change The Atrtibutes Of The "Find And Replace" in Access 4
access97 to 2002 search button conversion error 2
Modifying the Default "Look In" Field for in a Search Prompt 1

Top