How to make a field in Access 2013 flash

[cpchainsaw]

I am trying to get a calculated due date to flash on/off or changing colors on a form. The field name is [CA DUE DATE].

[OTWarrior]

To set up an object to flash red and black, you need to place VBA code on the Form's "On Timer" event.First, select the "On Timer" property on the Form. You can choose the interval.

Then add this code


Private Sub Form_Timer()

If [CA DUE DATE]< Date Then
If [CA DUE DATE].ForeColor = vbRed Then
[CA DUE DATE].ForeColor = vbBlack
Else
[CA DUE DATE].ForeColor = vbRed
End If
End If

End Sub