Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Force text field to upper case when updating record 1

Status
Not open for further replies.

cmmrfrds

Programmer
Feb 13, 2000
4,690
US
I have a 1 byte text field that I want to force to upper case when the user enters data. Is there an easy way to do this? Thank you.
 
You can make it DISPLAY in upper case by putting a greater than symbol in the Format property

--Lilliabeth
 
How are ya cmmrfrds . . .

In the KeyPress event of the control:
Code:
[blue]   If KeyAscii > 96 And KeyAscii < 123 Then
      KeyAscii = KeyAscii And 223
   End If[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue] [thumbsup2]
Also faq181-2886 [blue]Worthy Reading![/blue] [thumbsup2]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top