Search question Rich Wonneberger <turtil[ at ]frontiernet.net> 12/17/2008 12:47:02 AM 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.

RE: Search question Dorian 12/17/2008 10:16:01 PM 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: [Quoted Text] > 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. >

Re: Search question Rich Wonneberger <turtil[ at ]frontiernet.net> 12/18/2008 2:53:27 AM 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: [Quoted Text] > 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. >>

Re: Search question "JulieS" <JulieS[ at ]discussions.microsoft.com> 12/19/2008 2:18:55 PM 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" <turtil[ at ]frontiernet.net> wrote in message news:uYaDMvLYJHA.1328[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] > 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. >>>

Re: Search question Rich Wonneberger <turtil[ at ]frontiernet.net> 12/24/2008 2:37:39 AM 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: [Quoted Text] > 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 >

Re: Search question "JulieS" <JulieS[ at ]discussions.microsoft.com> 12/27/2008 3:17:58 PM You're welcome Rich. "Rich Wonneberger" wrote in message news:uwTsXCXZJHA.256[ at ]TK2MSFTNGP06.phx.gbl... [Quoted Text] > 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 >>

Re: Search question "Linq Adams via AccessMonster.com" <u28780[ at ]uwe> 12/28/2008 4:50:06 PM 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/Forums.aspx/access-gettingstarted/200812/1