How to make rows blinking in access

Ahmad Arief Mohd Nor 196 Reputation points
2021-08-11T03:02:50.997+00:00

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

Microsoft 365 and Office | Access | Development
0 comments No comments
{count} votes

Answer accepted by question author
  1. DBG 11,531 Reputation points Volunteer Moderator
    2021-08-11T19:37:26.64+00:00

    One way to do it is to also use Conditional Formatting in conjunction with your Timer.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.