Flash Textbox Backcolor White and Red

[Power]

Hi, I have searched for code to flash the backcolor of a text box but haven't found what I want. I am sure it is a simple timer but I know just enough to be dangerous.



If a user changes a date in a text box (SubmitDate) on form 1 and tabs out of the field, I have code in the AfterUpdate event to update this date change on a text box on form 2 (that is also open) so they stay in sync. I have some code that changes the backcolor of the text box on form 2 to red, then changes it to white, then red again and then back to white so it appears to flash, but it is very inefficient. Is there a simple way to alternate the backcolor from white to red, to white, to red, then back to white with a 1/2 second interval between each color change? I am using DoEvents so I can continue other processes while it changes color.


Thanks in advance!

[Toyman]

Hi, I have searched for code to flash the backcolor of a text box but haven't found what I want. I am sure it is a simple timer but I know just enough to be dangerous.

If a user changes a date in a text box (SubmitDate) on form 1 and tabs out of the field, I have code in the AfterUpdate event to update this date change on a text box on form 2 (that is also open) so they stay in sync. I have some code that changes the backcolor of the text box on form 2 to red, then changes it to white, then red again and then back to white so it appears to flash, but it is very inefficient. Is there a simple way to alternate the backcolor from white to red, to white, to red, then back to white with a 1/2 second interval between each color change? I am using DoEvents so I can continue other processes while it changes color.


Thanks in advance!

set the form timer to 1000. This equals one second interval. If you want to have it flash faster, reduce the number until desired interval. Put the is the "On Timer" event of the form

If Me.YourFieldNae.BackColor = 255 Then
Me.YourFieldNae.BackColor = 16777215
Else
Me.YourFieldNae.BackColor = 255
End If

[June7]

That code will initiate the flashing as soon as form opens. Is that what you want?

[Toyman]

Ok, the code was to provide example on how to get the flashing going. You must add additional conditions before the code in order to get the flashing going when you need it