G Gary Miller Nov 21, 2003 #2 Greg, Use the UCase() function in the AfterUpdate event of your text box... Me!YourTextboxName = UCase(Me!YourTextboxName) -- Gary Miller Gary Miller Computer Services Sisters, OR ________________________
Greg, Use the UCase() function in the AfterUpdate event of your text box... Me!YourTextboxName = UCase(Me!YourTextboxName) -- Gary Miller Gary Miller Computer Services Sisters, OR ________________________
B Bruce M. Thompson Nov 21, 2003 #3 How do I force a response to be Uppercase only In addition to Gary's solution, you can force uppercase as the user types with code in the control's "KeyPress" event procedure: '**********EXAMPLE START Private Sub txtUpper_KeyPress(KeyAscii As Integer) KeyAscii = Asc(UCase(Chr(KeyAscii))) End Sub '**********EXAMPLE END
How do I force a response to be Uppercase only In addition to Gary's solution, you can force uppercase as the user types with code in the control's "KeyPress" event procedure: '**********EXAMPLE START Private Sub txtUpper_KeyPress(KeyAscii As Integer) KeyAscii = Asc(UCase(Chr(KeyAscii))) End Sub '**********EXAMPLE END
F fredg Nov 21, 2003 #4 Greg said: How do I force a response to be Uppercase only Greg Click to expand... Greg, Don't bother. Let the entry be however the user wishes to enter it. Code the AfterUpdate event of that control: [ThisControl] = UCase([ThisControl])
Greg said: How do I force a response to be Uppercase only Greg Click to expand... Greg, Don't bother. Let the entry be however the user wishes to enter it. Code the AfterUpdate event of that control: [ThisControl] = UCase([ThisControl])
