asked on

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?

Joe Overman

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,

Milewskp

ASKER

Hi masterjojobinks,
I want to change the default behaviour of the built-in find/replace feature.

ASKER CERTIFIED SOLUTION

Joe Overman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Joe Overman

Sorry, would not could.

Joe Overman

You might try this as part of your own interface:
http://allenbrowne.com/AppFindAsUType.html

puppydogbuddy

try this:
Application.SetOption ("Default Find/Replace Behavior"), 2 'Start of field search

Milewskp

ASKER

Hi puppydogbuddy,
That option doesn't do what I want.

puppydogbuddy

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.

Milewskp

ASKER

Thanks!