Access 2003 defaults

[robert382]

Hi
Does anyone know how to chage the
following default setting in Access 2003?

Under "Find and Replace" the default setting
is "Whole Field", I want to change it to
"Any Part of Field".

Is there any way to do this?

Thanks, Bob

[missinglinq]

Choose Options from the Tools menu. On the Edit/Find tab, set:

Default find/replace behavior

to:

General Search

If I remember correctly, you'll have to close Access then re-open it before this change takes place.

Welcome to Bytes!

Linq ;0)>

[ADezii]

To do it in code would be:

Application.SetOption "Default find/replace behavior", 1

[missinglinq]

Keeping in mind that after the code executes, Access still has to be closed then re-opened before the changes take place.

Linq ;0)>

[robert382]

Choose Options from the Tools menu. On the Edit/Find tab, set:

Default find/replace behavior

to:

General Search

If I remember correctly, you'll have to close Access then re-open it before this change takes place.

Welcome to Bytes!

Linq ;0)>

Thank You, this is what I was looking for. Bob