When you use the binoculars to search for a record, is there any way to customize the default setting? (i.e. Always pulls up with "Any Part of the Field" selected)

I'm not sure if you can alter the access find parameters but you can set up the same on your own form. Set up an unbound textbox eg txtSearchText and add a button to the form (without the wizard)

on the onclick event of the button

set the code to the following

Dim strCriteria as string
strCriteria = me.txtSearchText
docmd.findrecord strCriteria, acAnywhere, , , , acAll

this will search all fields for the string you typed into the box in any part of any field. Have a look in help for FindRecord to explain the syntax and how you can play with it.

HTH

add a button but when the wizard comes up cancel. goto the properties on the button and goto on click, then add a Macro, call it FIND or something, then scroll down to Find Record. Then at the ottom of the screen goto Match choose any part of field.

http://www.access-programmers.co.uk/ubb/smile.gif

If you still want to use the binoculars go to Tools...Options...Edit Find and select general search.It will now default to any part of table,query etc and any part of field.