Color change in form filed

[miziri]

Hi,
I want in form the color change into red color when I forget to enter the value into that filed.



thx

[RuralGuy]

It is the BackColor and you would set it in the BeforeUpdate event of your form.

[miziri]

Hi RuralGuy,

Can please me code programmer for that


thank from Iraq country miss peace

[RuralGuy]

Something like:

Private Sub Form_BeforeUpdate(Cancel As Integer)
   If Len(Me.YourControl) = 0 Then
      Me.YourControl.BackColor = RGB(255, 0, 0)
      Cancel = True
   End If
End Sub

...using YourControl name of course.