Force all text to Upper Case in Web Form

PDIS
PDIS used Ask the Experts™
on
How do I force all text to display in upper case for an Access web form that is used on Sharepoint?  Both Access and Sharepoint are 2010.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
QPR

Commented:
You could do this with CSS, for example

<style type="text/css">  
#myTextBox  { text-transform: uppercase; }  
 </style>

Author

Commented:
Is there a way to do this inside of Access?
Kash2nd Line Engineer
Commented:
There are two possibilities. One can use an input mask that will force all upper case letters. This works fine when the data is all letters. Another possibility is converting it afterwards. In the After Update Event of the control use:

Me.controlname = UCASE(Me.controlname)

Hope this helps
Another way is to add this to the control's OnKeyPress event:
   KeyAscii = Asc(UCase(Chr(KeyAscii)))

This capitalizes each letter as the user enters it.

Author

Commented:
Both of these solutions do exactly what I need.  Thank you!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial