• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 403
  • Last Modified:

Find and Replace in Access

I use the Ctrl F button a lot when searching through access forms. I always have to change the letting for "Look In" and "Match". By default the "Look In" is the current highlighted field and I have to change it to the whole form. The Match by default is always "Whole Field" and I have to change it to "Any Part of Field".

Is there anyway to change the defaults on this? So when I hit Ctrl F I don't have to change those? Thanks!
0
cansevin
Asked:
cansevin
1 Solution
 
pdebaetsCommented:
This link shoud help: http://www.pcreview.co.uk/forums/find-ctrl-f-default-settings-t3647609.html

You will probably have to close and open the database for the changes to take effect.
0
 
cansevinAuthor Commented:
Thanks!
0
 
Jeffrey CoachmanMIS LiasonCommented:
Some notes...

Unless *every* field in the table needs to be searched, it may be resource intensive to search the "Whole Form"

It is possible to build a query system to do this and skip the dialog box altogether.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now