Color change in text entry box to signify mandatory field

[STPMB]

This is probably an easy question but before a user can exit a form what code would I use to change the color of a text entry control to notify the user that the field is mandatory?

 

[CCLINT]

Text1.BackColor=vbRed
Text1.ForColor=vbBlack
[/b][/i][/u]*******************************************************
_{General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[Foada]

Generally it is done with the forecolor, backcolor, or simply adding the text "required" something like this

Private Sub Command1_Click()
Text1.BackColor = vbRed
Text1.ForeColor = vbBlack
Text1.Text = "Required Field"
End Sub

Hope this helps. If you choose to battle wits with the witless be prepared to lose.

 

[CCLINT]

That was just an example but I would suggest not using red.
You might want to change the color of the label instead.
Or from the start identify to the user which fields are required by adding an identifier next to the text box, or putting a border around the text box. [/b][/i][/u]*******************************************************
_{General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}