Default Find/ Replace behaviour

Under Tools/ Options/ EditFind/ Default find/replace behaviour, there are three options:
"         Fast Search: Search only the field the cursor is currently in; match whole field.
"         General Search: Search entire table; match any part of field.
"         Start Search: Search only the field the cursor is currently in; match only first characters of field.

Is there any way (using code or otherwise) to set the default behaviour to: Search only the field the cursor is currently in and match any part of field?
LVL 1
MilewskpAsked:
Who is Participating?
 
Joe OvermanEngineerCommented:
There is no way to programmatically change the behavior or defaults of the find and replace interface.  To accomplish what you want, you could have to create your own interface that looks the same and does whatever you want.
0
 
Joe OvermanEngineerCommented:
Assuming you are wanting look on a form you could use this statement attached to a command button:

DoCmd.FindRecord "search value", acAnywhere, , acSearchAll,,acCurrent,
0
 
MilewskpAuthor Commented:
Hi masterjojobinks,
I want to change the default behaviour of the built-in find/replace feature.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Joe OvermanEngineerCommented:
Sorry, would not could.
0
 
Joe OvermanEngineerCommented:
You might try this as part of your own interface:
http://allenbrowne.com/AppFindAsUType.html
0
 
puppydogbuddyCommented:
try this:
       Application.SetOption ("Default Find/Replace Behavior"), 2 'Start of field search
0
 
MilewskpAuthor Commented:
Hi puppydogbuddy,
That option doesn't do what I want.
0
 
puppydogbuddyCommented:
Hi Milewskp,
The only other options I am aware of are:

 Application.SetOption ("Default Find/Replace Behavior"), 0 'Fast SearchCode:
 Application.SetOption ("Default Find/Replace Behavior"), 1 'General Search

You are welcome to try, but I don't believe they do what you want either.
0
 
MilewskpAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.