Solved

UPPER CASE entry field

Posted on 2002-05-23
17
238 Views
Last Modified: 2010-05-02
Hi

I would like to convert the lower case caracter to upper case in an entry field, as they are entered.  How should i proceed ?
thanks in advance
0
Comment
Question by:pchaloux
  • 5
  • 4
  • 4
  • +3
17 Comments
 
LVL 5

Expert Comment

by:bob_online
Comment Utility
in the keydown event

KeyCode = Asc(Ucase(Chr$(KeyCode)))

This converts the keycode to a character, converts the cuaracter to upper case and converts that back to a keycode integer
0
 
LVL 5

Expert Comment

by:bob_online
Comment Utility
I'm sorry, that was almost right:  do this in the KeyPress event instead:

KeyAscii = Asc(UCase(Chr$(KeyAscii)))
0
 
LVL 6

Expert Comment

by:holli
Comment Utility
You can use the following Code:

Private Sub TextboxName_KeyPress(KeyAscii As Integer)
    If KeyAscii >= 97 And KeyAscii <= 122 Then KeyAscii = KeyAscii - 32
End Sub

Alter "TextboxName" to the name of the textbox in your project.


holli
0
 
LVL 18

Expert Comment

by:bobbit31
Comment Utility
yes, but if you cut and copy lower case text then the above code will not work... try this instead:

Private Sub Text1_Change()
    Text1.Text = UCase(Text1.Text)
End Sub
0
 
LVL 16

Expert Comment

by:Richie_Simonetti
Comment Utility
This example not only shows how to do what you want but a bunch of others usefull stuf:
http://www.mvps.org/vbnet/code/textapi/txstyles.htm
0
 

Author Comment

by:pchaloux
Comment Utility
Private Sub Text1_Change()
   Text1.Text = UCase(Text1.Text)
End Sub

That way, my text is spell backward ...

I'm not using VBNet
0
 
LVL 18

Accepted Solution

by:
bobbit31 earned 100 total points
Comment Utility
how bout this:
Private Sub Text1_Change()
    Dim ix As Integer
    ix = Text1.SelStart
    Text1.Text = UCase(Text1.Text)
    Text1.SelStart = ix
End Sub
0
 
LVL 16

Expert Comment

by:Richie_Simonetti
Comment Utility
Optionally,
Private Sub Text1_LostFocus()
With Text1
    .Text = UCase$(.Text)
End With
End Sub
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:pchaloux
Comment Utility
ok, that should do it.
Thank you, guys
0
 
LVL 16

Expert Comment

by:Richie_Simonetti
Comment Utility
'From www.mvps.org/vbnet

Private Declare Function GetWindowLong Lib "user32" _
   Alias "GetWindowLongA" _
  (ByVal hwnd As Long, _
   ByVal nIndex As Long) As Long
   
Private Declare Function SetWindowLong Lib "user32" _
   Alias "SetWindowLongA" _
  (ByVal hwnd As Long, _
   ByVal nIndex As Long, _
   ByVal dwNewLong As Long) As Long

Private Declare Function SendMessage Lib "user32" _
   Alias "SendMessageA" _
  (ByVal hwnd As Long, _
   ByVal wMsg As Long, _
   ByVal wParam As Long, _
   lParam As Any) As Long
     


Private Sub Form_Load()
Const GWL_STYLE As Long = (-16)
Const ES_UPPERCASE As Long = &H8&
Dim defstyle As Long

defstyle = GetWindowLong(Text1.hwnd, GWL_STYLE)
   
Call SetWindowLong(Text1.hwnd, GWL_STYLE, _
                                  defstyle Or ES_UPPERCASE)
     
End Sub
0
 
LVL 18

Expert Comment

by:bobbit31
Comment Utility
> ok, that should do it.
Thank you, guys

are you gonna accept an answer then?
0
 

Author Comment

by:pchaloux
Comment Utility
Sorry ,
I thought I did, but I forgot to grade it.
So there you go !
0
 
LVL 18

Expert Comment

by:bobbit31
Comment Utility
thanks!
0
 
LVL 16

Expert Comment

by:Richie_Simonetti
Comment Utility
Glad you "won" Bobbit31, but strange choice to me.
Cheers
0
 

Author Comment

by:pchaloux
Comment Utility
Dear Richie_Simonetti,

I hope that your feelings aren't hurt.
I'm sure that your answers were very good, but I think that 30 lines of code to change characters to upper case is a bit too much, this time.

Please, don't answer to this message.  
I gave my grades.  
It's final and without any appeal.
Let's get on with our lives.

ok, bye
0
 
LVL 2

Expert Comment

by:ventond
Comment Utility
You could also use the Masked Edit Control, in which case you won't have to write any code. Just set a mask.
0
 
LVL 16

Expert Comment

by:Richie_Simonetti
Comment Utility
Nobody tries to appeal, you can keep your grades where they are.
I was not talking regarding only my comment. Sorry if it appears so.

Have a nice day.
Cheers
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now