Using the ‘Find Dialog Box’ on a Form (Access 97)

Topic

New Reply

I have created a runtime version that has a custom menubar on a form. One of the choices for the user is the “find” function. When the “Find Dialog Box” is opened, the default value for the Match: option is “Whole Field”. How can I change the default value to be “Any Part of Field”? Is this possible?

Reply | Quote

Replies

Have a look at this thread about more or less the same question.

You will have to create a custom CommandBarButton that calls a public function in a module. You must set the find options by either using SendKeys (not recommended, it’s flaky and language dependent) or by issuing a dummy search before opening the find dialog box. For example:

‘ Search for something innocent in order to set options
DoCmd.FindRecord ” “, acAnywhere, False, acSearchAll, True, acCurrent, True
‘ Open Find dialog box
RunCommand acCmdFind

You can look up FindRecord in the online help to learn about the arguments to FindRecord.

Reply | Quote

Thanks for the help – that got me back on track.

Reply | Quote