How do I set a field to automatically capitalize text?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know there is a way - I've done it in older versions - but I cannot find
the info for Access 2003.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the color of each capital letter in a rich text memo field. 0
Capitalize text in a field 8
Update query to capitalized text 3
How do I set it up to automatically capitalize the 1st letter? 2
Capitalize first letters in field 5
Capitalize first letters 5
format a text field 1
Excel How to enable engineering functions in MS Excel 2000? 3

Back
Top