Text field to change color when clicked

[RichO]

Here is what seems to be a bit of a unique application.

I have a continuous form where when a user clicks on the name field, I want the name field's back color to change. I accomplished this using a hidden yes/no field along with conditional formatting. See attached example (Access 2K).

When a user clicks to a different name I want the previous field to change back to its original back color. I did this using the field's lost focus event and when you click to another field the back color does change correctly, BUT the cursor then does not move the new field that was just clicked, as if the lost focus event caused an interruption, which is probably the case. Just having a hard time finding a work-around for it.

In a nutshell, I want only the name field with the focus to have a different back color.

Any ideas?

Thanks

 

[John Big Booty]

Your problem may be with the hidden check box.

Why not set the Back color using the "On Got Focus" event and set it back on the "On Lost Focus" event, and get rid of the hidden check box?

 

[RichO]

Why not set the Back color using the "On Got Focus" event

Because it is a continuous form, all occurrences of that field will change color, not just the current record. I think I neglected to mention in my original post that it was a continuous form. I will edit it...