Search question

  • Thread starter Thread starter Rich Wonneberger
  • Start date Start date
R

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

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
 
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.
 
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.
Click to expand...
 
Julie,

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

Thanks again
Rich W.
 
Back
Top