question

AhmadAriefMohdNor-2381 avatar image
0 Votes"
AhmadAriefMohdNor-2381 asked thedbguy answered

How to make rows blinking in access

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

office-access-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

thedbguy avatar image
0 Votes"
thedbguy answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.