Changing color in a field

[bseche]

Is there a way when a user enters a data in a field it will auto change the color to other fields.
For example There's a field called "in storage" once the user enter a data in that field i want access to make the first name, last name and social security to be the color red.
Thank you in advance

 

[rschultz]

assuming you have this on a form and your textbox for entering the data is called EndDate... try this:

Private Sub enddate_KeyPress(KeyAscii As Integer)
Me!enddate.BackColor = 255

End Sub

The color will be what ever you want (probably the default white) until the user presses the first key. Then the textbox will turn Red.

Hope that helps.