Find and Replace

[ND1994]

We do alot of find and replace in our main form (CTRL+F). The glitch is that once the pop-up box for "Find and Replace" appears, we almost always have to change the search setting from "Whole Field" to "Any Part of Field". Is there a way to set the default to "Any Part of Field" instead so that we don't have to change the setting every time?

 

[RoyVidar]

In Tools | Options the Edit/Find tab, select General Search in stead of Fast Search. You may have to close and restart Access for it to take effect.

 

[ghudson]

You can also control the Default Find/Replace Behavior option with VBA.

    Application.SetOption ("Default Find/Replace Behavior"), 0 'Fast Search

    Application.SetOption ("Default Find/Replace Behavior"), 1 'General Search

    Application.SetOption ("Default Find/Replace Behavior"), 2 'Start of field search

And you do not have to restart Access 2003 for it take effect.

 

[jempie]

following on from this I have a similar problem.

I need to set the options on the replace wizard.

Find: And
Replace: and
Search: case sensitive
Look In: ColumnC
Match: Any Part of Field.

Can anyone tell me how i can set these options?

Thanks.