Force upper case text in a form

I have a simple login dialog box that has a text box (txtUser) and a Login button (cmdLogin).  The user will type their initials in the text box then clicking the login button verifies the initials and passes the txtUser to a global public variable (gstrUser).  I would like the gstrUser text to always be upper case so when they modify a record their initials are entered in the UserID field in the form.

How can I make gstrUser always be caps???

Thanks
beyondtAsked:
Who is Participating?
 
BrentTempleConnect With a Mentor Commented:
When you pass the txtUser into the gstrUser, you could switch it to uppercase.   I'm assuming the command botton runs a little bit of vb.

gstrUser = UCASE(me.txtUser)

-Brent
0
 
Excalibur_SoftwareCommented:
another place you may want to add that code might be the before update event

Private Sub Form_BeforeUpdate(Cancel As Integer)

   gstrUser = Ucase(me.txtUser)

End Sub
0
 
beyondtAuthor Commented:
Thanks!!  There are many more questions to come.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.