Searches

[Dan Nakari]

Can someone tell me how when I click search in a tables / form / or query
how I can make the default in the Match : to always read "any part of the
field" versus the default of "whole field"?

Thanks

 

[Brian]

Tools -> Options -> Edit/Find -> General Search.

However, this also makes it include all fields, not just the current field.
Here's the help clip:

Sets the default behavior of Microsoft Access Find/Replace operations.
Select Fast Search to search the current field and match the whole field.
Select General Search to search all fields and match any part of the field.
Select Start Of Field Search to search the current field and match the
beginning character(s) of the field.