I have a continuous form. I can add/change/delete. When I add a record I try to set the backcolor to red. However all of the controls for the text box are set to red. I just want to change the backcolor of that one control to red. How can I do that?
Here is the snippet of code. Hexcolor is a subroutine which sets the color to red.
ElseIf IsNull(Me.SchTime) Then
Response = MsgBox("Please enter the time", vbInformation)
Me.SchTime.SetFocus
Me.SchTime.BackColor = HexColor("CC0000")
Exit Sub