I am currently making some changes to our company db. One of my biggest requests is to change the default "MATCH" setting in the edit/find function to search "ANY PART OF FIELD". You can do this through tools>options>edit/find and set the behavior to "GENERAL". The problem here is that doing that changes to default "LOOK IN:" setting to the whole form or table. This is absolutely worthless to me because i still then have to click the setting back to the field I'm trying to search.
So does anybody know a way to set the edit/find to "MATCH" field to "ANY PART OF FIELD" while keeping the "LOOK IN:" field set to the current field?
So does anybody know a way to set the edit/find to "MATCH" field to "ANY PART OF FIELD" while keeping the "LOOK IN:" field set to the current field?