Force Text to Uppercase

DazedConfused · May 16, 2004

What code do I use to force All text to uppercase?
I know I have seen this code elsewhere but can't remember where.

Thanks

Damon Heron · May 16, 2004

In the after update event of the textbox, put:
Me!txtYourName = UCase(txtYourName)

Damon

Graham R Seach · May 17, 2004

Or set the control's Format property to ">".

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