I was looking into the Tag control to get my control's background color to change as I tab through my form. I don't think this is going to work. Is there a better way to do this without setting each control's GotFocus, LostFocus events?

Hqve q look to
http://www.access-programmers.co.uk/ubb/Forum1/HTML/002869.html

(!àç&?@# English keyboard!)

Qlex

My solution is to add code similar to this to a Module and then call the code from the On Got Focus with =ColorOn("FormName") and On Lost Focus events with =ColorOff("FormName")

Function ColorOn(FormName As String)
Dim Frm As Form
Set Frm = Forms(FormName)
Frm.ActiveControl.BackColor = 8454143
End Function

Function ColorOff(FormName As String)
Dim Frm As Form
Set Frm = Forms(FormName)
Frm.ActiveControl.BackColor = -2147483643
End Function

Alexandre:
Thanks for the thread reference. I opted with the changing of the back style to transparent. That worked just fine. I guess if you wanted a different color to show after you fill in a field, you would go with something like Jack's idea.

Jack: I need to apply your idea to another situation. My thanks to you as well.