Change default for search button

[Guest]

Office 2007, How do I change the search button from "Whole field" to "Start
of Field"?

 

[Allen Browne]

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