• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 401
  • 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!
1 Solution
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.
cansevinAuthor Commented:
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.
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

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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