How do I set a field to automatically capitalize text?

K

KT

I know there is a way - I've done it in older versions - but I cannot find
the info for Access 2003.
 
G

Graham R Seach

If all you want to do is *see* the text in uppercase, add the greater-than
symbol ( > ) to the control's Format property. However, if you actually want
to change the text to uppercase, then add the followng to the control's
AfterUpdate event:
Me.txtMyText = UCase(Me.txtMyText)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
Top