Results 1 to 9 of 9
  1. #1
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: always in caption... (2000 sr.1)

    What od you mean by "Caption mode"? Do you mean "All capital letters"?

    Is there code in the textbox events to change it to all uppercase?

    Steve

  2. #2
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: always in caption... (2000 sr.1)

    sorry for my english... All capital letters

    If you want, an example for the mode...
    Tks for patience

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: always in caption... (2000 sr.1)

    You didn't answer the second question:
    Is there code in any of the textbox events to change it to all uppercase?

    Steve

  4. #4
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    always in upper case... (2000 sr.1)

    Subject edited by HansV to make it more relevant for future searches

    ... i have a txtbox into a userform and the porblem is:
    during i write in this txtbox to make appear the text always in caption mode...
    indipendent if i have press a caps lock or not...

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: always in upper case... (2000 sr.1)

    To change the text in a text box to upper case (capitals), use the After Update event:

    Private Sub TextBox1_AfterUpdate()
    Me.TextBox1 = UCase(Me.TextBox1)
    End Sub

    You must substitute the name of your text box, of course.

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: always in upper case... (2000 sr.1)

    Perhaps I misunderstood the original question. I was thinking the combobox was already doing this and he did not understand why.

    Steve

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: always in upper case... (2000 sr.1)

    I interpreted "to make appear the text always in ..." as a description of what Salvatore wanted to accomplish, but we'll have to wait and see how he reacts.

  8. #8
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: always in upper case... (2000 sr.1)

    Hi, in effect if i insert "p" during the inserting character i want this in capital letter "P" , and not after update event...

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: always in upper case... (2000 sr.1)

    Instead of the After Update event, use the KeyPress event:

    Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
    If KeyAscii > 96 And KeyAscii < 123 Then
    KeyAscii = KeyAscii - 32
    End If
    End Sub

    Again, replace TextBox1 by the name of your text box.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •