I would like to be able to change font color and appearance while entering data into a form (example: italicize a word). Is there any way to activate the font format while in a form?
I've uploaded a screen shot(I think). When you click on EPA Stations, 3 text boxes named E1, E2, and E3 toggle between yellow and green using the Timer Event. What I would like to do is use a Combo Box and select an individual item and have it toggle background colors.
I am using some simple code (below) to toggle the back ground color of text boxes.
Case "EPA Stations"
With Forms!NXT_locator!E1
.BackColor = (IIf(.BackColor = vbYellow, vbGreen, vbYellow))
With Forms!NXT_locator!E2
.BackColor = (IIf(.BackColor = vbYellow, vbGreen, vbYellow))
With...