Access default to "any part of a field" in search

[focusben]

My access Data base defaults to "whole Field" in search mode. How do I get
it to default to "any part of the field"?

 

[Allen Browne]

Try:
Application.SetOption("Default Find/Replace Behavior", 1)