change default setting for "find" function

[Guest]

How do I change the default setting for the "find" function from "whole of
field" to "start of Field" with Access 2007?

Thanks

 

[Allen Browne]

Go to:
Office Button | Access Options | Advanced
and set Default find/replace behavior to:
Start of field search

 

[Guest]

Brilliant! Many Thanks
John

Go to:
Office Button | Access Options | Advanced
and set Default find/replace behavior to:
Start of field search

 

[Guest]

What's the Office Button?

 

[Guest]

Nevermind... I'm not using Access 2007.

 

[Lisa]

Allen: The options are not the same for Excel 2007. Do you know how to set
the default find/replace options for this application? You help is greatly
appreciated.