Change Color of Background on Focus

[Quality]

I want to change the background color of each field in a form on focus to yellow and back to white when not the focus.
Is there an easy way to do this?

[scottowens]

I believe so, basically you want to change the value of the backcolor value

So create to events one on get focus and one on lost focus and the event will just modify the properties of the textbook

I'm going on from memory, but like

textboxname.backcolor= BLAH

I think

Scott Owens

[MMcCarthy]

I want to change the background color of each field in a form on focus to yellow and back to white when not the focus.
Is there an easy way to do this?

Try playing around with conditional formatting. Click on a text box and then go to the Format menu to find it.

[missinglinq]

Like Mary said, Conditional Formatting's the way to go! Select the control, goto Format > Conditional Formatting. Drop down the box for Condition 1 and select Field Has Focus. Now click on the Backgrounfd Color Icon and choose you're background color.

[NeoPa]

Conditional formatting is the easiest but I believe it came in on or after Access 2K, so earlier versions will still need to use the VBA approach described by scottowens.