CONTROL CASE - FORCE UPPER CASE

  • Thread starter Thread starter Sammie
  • Start date Start date
Instead of forcing them to use Upper Case, you can use the UCASE function to
convert whatever they type into upper case. In the AfterUpdate event of
your textbox put:

Private Sub CustName_AfterUpdate()
Me.CustName= UCase(Me.CustName)
End Sub

*NOTE: Replace CustName with the actual name of your textbox
--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


Sammie said:
Is there a way force a user to use all upper case in a partular field?
Thanks
Sammie
Click to expand...
=----
 
On the Form page in design mode under Format enter > symbol

Bruce
Sammie said:
Is there a way force a user to use all upper case in a partular field?
Thanks
Sammie
Click to expand...
=----
 
On the Form page in design mode under Format enter > symbol
Click to expand...

Note that this will *display* the text in upper case, no matter what's
typed, but it will store the data as typed.

John W. Vinson[MVP]
 
Place this in the form behind all text fields, ADDRESS to
the name of the field you want to capitalize. This is
done on forms and it will save it as caps. I found it to
be better than uCase.

Private Sub ADDRESS_KeyPress(KeyAscii As Integer)
KeyAscii = Asc(UCase(Chr(KeyAscii)))
End Sub
I have this in a detail document if you would like it
send me your e-mail address to the address listed above
 
Back
Top