Solved

Find and Replace in Access

Posted on 2013-05-23
3
342 Views
Last Modified: 2013-05-23
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
Comment
Question by:cansevin
3 Comments
 
LVL 12

Accepted Solution

by:
pdebaets earned 500 total points
Comment Utility
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
 

Author Closing Comment

by:cansevin
Comment Utility
Thanks!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
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

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now