Change default settings in "search"

[Duane]

Access 2007- - - Can someone help me to change the default setting when doing
a search? I would like to change the default "Match" field FROM - "Whole
Field" TO - "Any Part of Field".

 

[Philip Herlihy]

If you're using the simplest search available, simply go to the Home Tab and
click the Find button in the Find group (on the right by default). When the
dialogue pops up there's an option there to change this setting.

You can also filter, or write queries, using the wildcard symbols * and ?
(which match zero or more arbitrary characters, and any one character,
respectively). You can read about filtering and queries in Help.

Phil, London

 

[MikeJohnB]

Go to Office Button, Access Options, Advanced Category, Editing. Look for
Default Find/Replace Behavior, and set it to General Search. You have to
restart Access for this option to become active.

Not tested but I hope this helps??????

Regards

 

[Duane]

Thanks so very much MikeJohn - this is EXACTLY what I wanted. I knew it was
an easy fix - just didn't know where to go. It's great when there is always
someone out there that knows "were to go".
Thanks Again,
Duane

 

[Duane]

Philip - thanks for your efforts. However I was trying to CHANGE the
default settings - not access them. Mike (post below) was able to answer my
question.
Thanks again for your efforts.
Duane

 

[Jerry Whittle]

Is this required for only your computer or others using the database? Mike's
suggestion only works on that computer. If you need to control this behavior
on other computers using the database here's some info:

Check out Application.SetOption.

'Set some database defaults found in Tools, Options
' Put in the Open event of the startup form
' Set Default Locking to Edited Record
Application.SetOption "Default Record Locking", 2
' Set Default Open Mode for Databases to Shared
Application.SetOption "Default Open Mode for Databases", 0
' Set Default Find/Replace Behavior to Start of Field Search
Application.SetOption "Default Find/Replace Behavior", 2

Application.SetOption "ShowWindowsInTaskbar", True

In the case of "Application.SetOption "Default Record Locking", 2" Default
Record Locking has three choices and the one I want is the third so, of
course, I put in 2 for the arguement. That's because it starts numbering at 0
instead of 1.

Put the above code in the Open Event of your opening form. One other strange
thing is that the database may need to be opened and closed twice on the
user's computer for the change to take effect. The first time the database
opens, it makes the changes. The second time the changes are in effect.

 

[Philip Herlihy]

Yup - soon as I read Mike's post I realised I'd missed the all-important
word "default" in your post - whoops!

Phil