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

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.
891 questions
0 comments No comments
{count} votes

Accepted answer
  1. DBG 2,301 Reputation points
    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 Answers by the question author, which helps users to know the answer solved the author's problem.