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
[Reminder (Days)].BackColor = vbWhite
[Reminder (Days)].ForeColor = vRed
End If
End If

End Sub

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
830 questions
0 comments No comments
{count} votes

0 additional answers

Sort by: Most helpful