Windowed said:
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.