Looking for the parameter to search "Any Part of Field" in the Find dialog

P

Paul James

I'm using this line in VBA to open the Find and Replace Dialog in one of my
forms:

DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Two questions:

1. We almost always want to search for "Any Part of Field" but the dialog
initially opens with the Match field set to "Whole Field." Is there a
parameter I can use so the dialog will always open in "Any Part of Field?"

2. Is there another parameter that can be used to set what appears in the
"Look In" field in the dialog as well?

If you are able to answer these questions, please also tell me where in the
above code the parameters should be located.

Thanks in advance,

Paul
 

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

Top