HOW to Setfocus to a Required Field

R

Radar

Instead of geting the error msg.
How Setfocus to a required field that is blank. I want that field to
to blink with a color.

Thanks
Radar
 
A

Arvin Meyer [MVP]

Radar said:
Instead of geting the error msg.
How Setfocus to a required field that is blank. I want that field to
to blink with a color.
Click to expand...

Blinking/Flashing is always a bad idea because it irritates users. It will
come back to you eventually in an unpleasant way. If you insist ... set the
form's timer interval to an appropriate value (1000 would blink every
second). Then, In the timer event of the form:

If Me.txtBlinkingText.Backcolor = vbRed Then
Me.txtBlinkingText.Backcolor = vbWhite
Else
Me.txtBlinkingText.Backcolor = vbRed
End If


Where txtBlinkingText is the name of the text box which you want to blink.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top