I searched the forum, but what I found (AfterUpdate event and >C) doesn't work. I don't see any AfterUpdate event for a textbox, and putting >C in the DataFormat field of the text box doesn't work.
I need to change the letters to uppercase AS THE USER TYPES THEM. I tried this:
Private Sub myTextBox_Change()
Me.ActiveControl = UCase(Me.ActiveControl)
End Sub
but it puts the cursor at the beginning of the text box after you type each letter, so if I want to type "CUST", I end up with "TSUC".
Is there a way to use UCase() in the Custom format for the DataFormat field?
Thank you.
I need to change the letters to uppercase AS THE USER TYPES THEM. I tried this:
Private Sub myTextBox_Change()
Me.ActiveControl = UCase(Me.ActiveControl)
End Sub
but it puts the cursor at the beginning of the text box after you type each letter, so if I want to type "CUST", I end up with "TSUC".
Is there a way to use UCase() in the Custom format for the DataFormat field?
Thank you.