Changing Match option on Find/Replace form

Bob Hansen · July 15th, 2009, 12:11 PM

The line
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
brings up the Find and Replace dialog.

The default value for the Macth field is 'Whole field'

How can I automatically set the option Match to 'Start of Field' without clicking on it?

Bob Hansen · July 15th, 2009, 01:53 PM

I was able to get a solution from a Microsoft page:http://support.microsoft.com/kb/208923

The solution for me was the following code, using RunCommand vs. DoCmd:

Code:

SendKeys "%hs%n"
RunCommand acCmdFind

SerranoG · July 30th, 2009, 10:03 AM

The SendKey command is very useful when all else fails, but is also very dangerous. Use it sparingly!

If anything grabs the attention of your computer, say you have a new e-mail message and it pops up an alert window OR you printed something and the print confirmation pops up at the wrong time, then the SendKey strokes you just issued will apply to that window and not the search window.

Now imagine if the window that gets the focus is some program you're running in the background and it decides to become active at that point. Those SendKey commands could order it to delete records or something not so pleasant depending on the menu keys you just sent it...