Make Find Utility default to "Any Part of Field" instead...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Make Find Utility default to "Any Part of Field" instead of to "Whole Field".
It is so annoying to always have to change it! Or at least if you change
once when using Access, Access should remember and leave it that way so you
don't have to constantly change the setting.

This change would help in all parts of Access - Forms, Tables...
 
This is a public newsgroup where users can exchange advice, questions,
answers, etc. You would need to submit ideas for changes to Microsoft.

There should be a link on their website.

I think they also have an email address of (e-mail address removed)
 
Van, that's a great article, having all those option names in once place is
great.

It explains how to set the options for Tools | Options | Edit/Find, but not
the options for the Find dialog (as far as I could see.)

I don't have an answer for the OP, as I don't use the Find dialog from code.
There probably is something better than:
Sendkeys "%ha", False
 
Dear Allen and Van:

Well, I'm confused... I *thought* the OP was talking about setting options
in the "Find and Replace" dialog box (i.e. the one that pops up with
Ctrl-F). Specifially, the options in that dialog box for "Match: Start of
Field"; "Match: Whole Field" and "Match: Any Part of Field". The (corrected)
link *does* show how to do this in code... (Application.SetOption "Default
Find/Replace Behavior", 0)

Allen, what do you mean when you say the "Find dialog". Are you referring to
the "Find" dialog that pops up with Ctrl-F, or a different "Find" dialog?
Sorry if I am being dense!

Thanks!
Fred
 
I thought the same, too. IIRC correctly, I mucked around with this a few
years back.

AFAIK, the first setting "Default Find/Replace Behavior" in Edit/Find
Options which can be set to 0 (Fast Search), 1 (General Search) or 2 (Start
of Field) corresponding to the options you mentioned. 0 corresponds to
whole Field, 1 to any part of Field and 2 to start of Field.

I have just re-tested in A2002 to confirm the above.
 
Thanks, Fred and Van

You're both right. Because I don't use the Find dialog for users, I'd never
identified those options with it. Apologies for the confusion.
 
Well, I don't mind being right this one time, Allen, but I'll have you know
that I have absolutely no intention of making a habit of it! ;)

Fred

Allen Browne said:
Thanks, Fred and Van

You're both right. Because I don't use the Find dialog for users, I'd
Click to expand...
never
 
Back
Top