Label Flash is Balance = Zero

[Dave Elliott]

Tried this code, but with no luck!
Wanted to make label flash if balance was less than zero

With ([Balance]) < 0
.ForeColor = (IIf(.ForeColor = 0, 255, 0))
End With

 

[SteveS]

Tried this code, but with no luck!
Wanted to make label flash if balance was less than zero

With ([Balance]) < 0
.ForeColor = (IIf(.ForeColor = 0, 255, 0))
End With

Look at The Access Web:

Make a label flash:

http://www.mvps.org/access/forms/frm0020.htm