Search fields as formatted option is checked by default in 2003

[tweetyangel]

The "Search Fields As Formatted" option in the find dialog box is checked by default in Access 2003 and is slowing down searches tremendously. How can I change this default setting?

 

[GingerR]

Hi. I Googled the phrase "Search Fields as Formatted" and found lots of other people asking the same thing, none of which were ever answered. Found this article though here on MS:

http://support.microsoft.com/default.aspx?scid=kb;en-us;208923

I'm not sure how you are using this, but i made a subform of a table (datasheet) on a form which has a button on it. I click into the field/column I care about in the subform, then click the button. The OnClick code I made:

'User must put cursor into a field/column of the datasheet, then click the button
    SendKeys "%o", False
    Me.Form1.SetFocus
    DoCmd.RunCommand acCmdFind

Worked good, except that when the FIND window pops up, your cursor is not in the FIND drop-down. The "Search Fields as Formatted" label is lightly outlined, telling me that's where the focus is. I don't know how to make it plunk the cursor into the Find box.

Hope this gets you started though.

g