Search question

[Rich Wonneberger]

Every day when I start Access, the first time I search a table (or
query) with ctrl-f it wants to search for the exact text and 'as formatted'.
I have to un-select both options.
Is there a way to have it save the settings?

TIA
Rich W.

 

[Dorian]

No. However, if you do this programatically, there is a way to override the
settings of Ctrl-F each time you run it e.g. to make it default to 'any part
of field'.

-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Rich Wonneberger]

Can you point me in the right direction to this?
I searched in the help file but never found anything.

TIA
Rich W.

 

[JulieS]

Hi Rich,

You don't mention what version of Access you are using. In Access
2003 on the Edit/Find tab in Tools > Options, you can set the
default Find/Replace behavior. Fast search searches the currently
selected field and searches the whole field. General search
searches all fields and matches any part. Start of field search
searches current field and matches the beginning.

I hope this helps.

Julie

 

[Rich Wonneberger]

Julie,

It is 2003.
I did find the settings but did not have time to try them.
I think the general search may work better.
Have to try it when I go back to work Jan 2.

Thank You
Rich W.

 

[JulieS]

You're welcome Rich.

in message

Julie,

It is 2003.
I did find the settings but did not have time to try them.
I think the general search may work better.
Have to try it when I go back to work Jan 2.

Thank You
Rich W.

 

[Linq Adams via AccessMonster.com]

Understand that you have to change this option, then close down Access and re-
open it, in order for the change to take effect. Also note that this is an
Access-wide option. All databases run from this copy of Access will be set
this way.

 

[Rich Wonneberger]

Julie,

After using it all week I think its perfect.
I don't even have to select a field.

Thanks again
Rich W.