Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Onekama, Michigan, USA
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using the 'Find Dialog Box' on a Form (Access 97)

    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.

  3. #3
    Star Lounger
    Join Date
    Apr 2002
    Location
    Onekama, Michigan, USA
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using the 'Find Dialog Box' on a Form (Access 97)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •