Sinnah
06-01-2000, 04:20 AM
I am trying to make capital letters in my entry text box.
I do not put it take the capital string, could any one help me on this?
Many thanks in advance.
R. Hicks
06-01-2000, 04:34 AM
If you want the entry to be converted to all Upper Case, do this. Using the After Update event of the txtbox you are using place the following code:
Private Sub txtYourTextBox_AfterUpdate()
Me.ActiveControl = UCase(Me.ActiveControl)
End Sub
Change "txtYourTextBox" the the name of you control.
This will convert the entry to Upper Case no matter how it's entered.
HTH
RDH
Pat Hartman
06-01-2000, 08:04 AM
I think the BeforeUpdate event is what Rick ment.
R. Hicks
06-01-2000, 01:57 PM
Pat, I have always done this using the After Update event of the control, so I said "what the heck, I'll try it Pat's way" but I can't get it to work with the Before Update event of the control.
RDH
bill crumpton
06-02-2000, 06:45 AM
How come when I use the ">" symbol in the format section of a field's properties to capitalize all the text, this limits the number of characters I can type into the field?
Sinnah
06-12-2000, 07:42 AM
Thank you for the tip Mr Hicks. It is working with your code.
Many Thanks again.
Sinnah
Pat Hartman
06-12-2000, 07:47 AM
Sorry Rick, I read your answer too quickly. I thought you said the AfterUpdate event of the form. The AfterUpdate event of the control is fine.