"Find" question

[NJudson]

I'm using Access 2000 and when you hit Ctrl-F or use the Find function the Find/Replace box pops up and the 'Match' field is always defaulted to "Whole Field". Is there a way to change the default 'Match' field to "Any Part of Field". It's not a real big deal but it's one of those really annoying little pet peeves of mine. I very rarely have a need to run a Match on the "Whole Field" selection. Thanks.

 

[pdx_man]

Under Tools ... Options ... Edit/Find tab, select the General Search option under the Defualt Find/Replace Behavior section.

 

[NJudson]

Ok. I found how to do it. I found this site that says:

1) Select the 'Tools' menu and select 'Options...'. (The 'Options' dialog box appears.)
NOTE: If 'Options...' does not appear, click the down-arrow at the bottom of the 'Tools' menu to expand the menu.
2) Click the 'Edit/Find' tab.
3) In the 'Default find/replace behavior' group, do one of the following:
'Default find/replace behavior' group
a) To have Access search the current field and match the whole field by default, select the 'Fast search' radio button.
b) To have Access search all fields and match any part of the field by default, select the 'General search' radio button.
c) To have Access search the current field and match the beginning character or characters of the field by default, select the 'Start of field search' radio button.
4) To apply the new settings and close the 'Options' dialog box, click 'OK'.

Option b is what I want. The thing that bugs me is I already looked at this before but I never selected "General Search" because because I didn't understand what General Search meant.
Oh well, at least it works now.

 

[NJudson]

Thanks pdxman. Looks like you slid your answer in there right when I was typing mine up.

 

[pdx_man]

ya sure, ya betcha

 

[neileg]

Been wanting to change that for ages, and never got round to finding out how! Thanks fellas.