CONTROL CASE - FORCE UPPER CASE

[Sammie]

Is there a way force a user to use all upper case in a partular field?
Thanks
Sammie

 

[Roger Carlson]

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

Is there a way force a user to use all upper case in a partular field?
Thanks
Sammie

=----

 

[Bruce]

On the Form page in design mode under Format enter > symbol

Bruce

Is there a way force a user to use all upper case in a partular field?
Thanks
Sammie

=----

 

[John Vinson]

On the Form page in design mode under Format enter > symbol

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]

 

[lonnie]

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