How to change default settings in Access

[Guest]

I was hoping someone may be able to explain two different items. I am trying
to change the Find and Replace default setting of "Whole Field" to "Any Part
of the Field." Also, when inserting an object, is it possible to change the
default "Create New" to "Create from File." I have seen some references to
this but I am not sure of the code or even where to place it. Help would be
great.

Thanks in advance.

Mark

 

[Guest]

For the first part
In the ToolBar select Tools > Options > Search and Edit Tab > change the
search default there
You need to close Access and open again after changing the default

For te second part, sorry, mybe someone else can help there

 

[Guest]

Thanks a lot Ofer Cohen. I appreciate it, I'll hang tight for the other.