Simple Form.
The user can navigate through the table using the buttons on the bottom of the form. (working)
If the user gets to a record that has a status of "6", the label "DONE" appears on the screen (working)
While the user is on the "DONE" record, I want the word "DONE" to flash. (not working)
Here is the code I have in place:
------------------
With Forms!MAIN!TaskStatDisp
.ForeColor = (IIf(.ForeColor = vbRed, vbBlack, vbRed))
Me.TimerInterval = 15
.ForeColor = (IIf(.ForeColor = vbRed, vbBlack, vbRed))
.ForeColor = (IIf(.ForeColor = vbRed, vbBlack, vbRed))
.ForeColor = (IIf(.ForeColor = vbRed, vbBlack, vbRed))
.ForeColor = (IIf(.ForeColor = vbRed, vbBlack, vbRed))
End With
-------------------
any suggestions?????
The user can navigate through the table using the buttons on the bottom of the form. (working)
If the user gets to a record that has a status of "6", the label "DONE" appears on the screen (working)
While the user is on the "DONE" record, I want the word "DONE" to flash. (not working)
Here is the code I have in place:
------------------
With Forms!MAIN!TaskStatDisp
.ForeColor = (IIf(.ForeColor = vbRed, vbBlack, vbRed))
Me.TimerInterval = 15
.ForeColor = (IIf(.ForeColor = vbRed, vbBlack, vbRed))
.ForeColor = (IIf(.ForeColor = vbRed, vbBlack, vbRed))
.ForeColor = (IIf(.ForeColor = vbRed, vbBlack, vbRed))
.ForeColor = (IIf(.ForeColor = vbRed, vbBlack, vbRed))
End With
-------------------
any suggestions?????