One way to do it is to also use Conditional Formatting in conjunction with your Timer.
How to make rows blinking in access
Ahmad Arief Mohd Nor
196
Reputation points
I want to make each row blinking if criteria is met, but or now i only able to make all rows blink. How to I adjust my code so that each row will blink or not based on the value on each row?
Here are my code:
Private Sub Report_Timer()
If Not ([Reminder (Days)] >= 0) Or Not ([Reminder (Days)] <= 5) Then
If [Reminder (Days)].BackColor = vbWhite Then
[Reminder (Days)].BackColor = vbRed
[Reminder (Days)].ForeColor = vbWhite
Else
[Reminder (Days)].BackColor = vbWhite
[Reminder (Days)].ForeColor = vRed
End If
End If
End Sub