Search a Field

[doulostheou]

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)

 

[Fizzio]

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

 

[DocManDobie]

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.

 

[Jerry Stoner]

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.