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