Changing background color on controls

[johnroger]

Hello,
As I tab through a form, how can I change the color of the control that has just received the focus.

John

 

[naygl]

Try the OnGotFocus property of the control. Add code which will change the backcolour such as:

Me.Combo5.BackColour = 255

Then use the onLostFocus property to return it to its normal colour.

 

[SimonC]

As an alternative, if you're running Access 2000 or later, you could use Conditional Formatting.

In Form Design mode, select the control you want to highlight from the menu select Format -> Conditional Formatting. Select "Field Has Focus" as the condition and then set the appropriate formatting properties.

Simon.

 

[johnroger]

Hello Simon,

That's what I needed.

Thank you very much.

John R.