forms: find and replace dialog box: change default for match field

[Windowed]

How can I change the default for the Match field so that when I open the Find
and Replace dialog box with an Access form it defaults to "Any part of field"
?

I thought there might be a way to do with with VBA, but I can't find the
Find and Replace dialog box in the object table anywhere.

Thanks.

 

[KARL DEWEY]

Under TOOLS - Options - Edit/Find there are three choices.

General Search will do what you want but will also search all fields.

 

[Windowed]

Searching all fields is not satisfactory. I've read that there are all kinds
of ways to customize MS Office products using VBA. Is there any way to get
the functionality I need?

 

[Rick Brandt]

Searching all fields is not satisfactory. I've read that there are
all kinds of ways to customize MS Office products using VBA. Is there
any way to get the functionality I need?

I will repeat what I have said before on this topic.

Access has both features that are intended for *users* who are creating small
simple apps for their own use as well as features that are intended for
developers of full-blown professional applications.

You are asking for a way to do something advanced (customization) to a
user-feature that most developers never utilize (the built in Find tool).

There are methods using VBA and update queries that are far superior for
changing data than using Find and Replace and any seasoned developer would be
using those. So if you are wondering why no one is offering advice on how to
tweak the behavior of Find and Replace it's because no one that would have the
ability to figure that out uses Find and Replace.

If you want a customized method for changing data in your tables then forget
about Find and Replace and start researching on Update queries and creating
dynamic SQL statements.

 

[Windowed]

OK. I give up. I just wanted to help a client who has an Access DB and wants
to have a quick and easy way to find out if a customer is already in their
DB. This shouldn't require update queries and a lot of fancy programming.
Granted, it's a minor annoyance to have to change that setting each time, but
it should be an avoidable annoyance.