I may be asking for more then I am ready for. I have a Continuos form in access, so basically a list. I have one field in the table that is ColorCode and the value is 1, 2, or 3 and on the form the textbox is named txtColor. So on FormLoad, I want access to change the color of that text box to a new color based off the value. Now I think this is how it would look for a standard form:
Private Sub Form_Load()
If txtColor.Value = "1" Then txtColor.BackColor = green
End Sub
But how can I do this for a continuos form