Find and Replace

[Guest]

Hi, can anyone help me please, what makes the look in box become shaded in
the find dialogue box.

and how can I change this so that is it selective

Gail

 

[Allen Browne]

The Look In box is available in the Find dialog only when the active control
is bound to a field that can be searched.

For example, if the active control is a command button, you can't look in
that. Or if it is an unbound text box, there is no field to search.

If necessary, SetFocus to the control you want first.

 

[Guest]

can you help me out and tell me how to setfocus please

Gail

 

[Allen Browne]

If you are using a macro, use GotoControl.

If you are using VBA code, see help on SetFocus.
For example, to set focus to a control named City, you would use:
Me.[City].SetFocus

 

[Guest]

thanks for the help will give it a go, just a thought, why would the find and
replace box, which has been working find until last week suddenley stop
letting me select the box to search in, and be greyed out, and showing only
the query name the form is based on

If you are using a macro, use GotoControl.

If you are using VBA code, see help on SetFocus.
For example, to set focus to a control named City, you would use:
Me.[City].SetFocus

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

can you help me out and tell me how to setfocus please

Gail