Link to home
Start Free TrialLog in
Avatar of cansevin
cansevin

asked on

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!
ASKER CERTIFIED SOLUTION
Avatar of pdebaets
pdebaets
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cansevin
cansevin

ASKER

Thanks!
Avatar of Jeffrey Coachman
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.