mikkistr
11-16-2000, 12:39 PM
How can I require or convert to uppercase letters in text boxes on a form? Some special characters are allowed.
Thanks ahead for any help!
Thanks ahead for any help!
|
View Full Version : Convert to uppercase mikkistr 11-16-2000, 12:39 PM How can I require or convert to uppercase letters in text boxes on a form? Some special characters are allowed. Thanks ahead for any help! R. Hicks 11-16-2000, 01:27 PM If you are talking about converting to upper case in data entry, try using the After Update event of the textbox: Private Sub YourTxtBox_AfterUpdate() Me.ActiveControl = UCase(Me.ActiveControl) End Sub If you are refering to viewing previous data that you want to see as upper case then try: Using a field called "Name" from the table/query as an example: In the Control Source of the text box put: =Ucase[Name] HTH RDH |