Stop Blink with Requery

Novice1

Registered User.
Local time
Today, 10:16
Joined
Mar 9, 2004
Messages
385
I have a small alert form. I have the following procedure on timer (750). How can I get the count NOT to blink when the count is zero. The blink occurs regardless of the count (blinks when the requery is run). Thanks


DoCmd.Requery

If Me.CountQueue >= 1 Then

With Me.Label241
.ForeColor = (IIf(.ForeColor = vbRed, vbBlack, vbRed))

End With

Else

End If
 
You may wish to turn Echo on and off for this. I'm not positive it will work for you but it is worth a try.
 

Users who are viewing this thread

Back
Top Bottom