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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top