Search question

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.

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" wrote:

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.

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

TIA
Rich W.

Dorian wrote:
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" wrote:

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.

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" wrote in message
...
Can you point me in the right direction to this?
I searched in the help file but never found anything.

TIA
Rich W.

Dorian wrote:
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" wrote:

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.

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 wrote:
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

You're welcome Rich.

"Rich Wonneberger" wrote 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.
snip JulieS wrote:
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

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.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200812/1

Julie,

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

Thanks again
Rich W.

JulieS wrote:
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