View Full Version : Save/Convert Lower Case to ALL CAPS (UPPERCASE)


thorsonb
10-05-2009, 02:50 AM
How do I have my database automatically convert the contents of the cell to UPPERCASE
Bellow is the screen shot of my Database. (pic also here http://tinypic.com/r/2ho943s/4)



I would like to have the info entered @ Last_Name & @ Address saved to uppercase!

DCrake
10-05-2009, 03:33 AM
Use >L in your input mask

or use UCase([FieldName]) on the before/After Update event on your form.

David

RuralGuy
10-05-2009, 07:02 AM
I would *strongly* suggest that you not do this. Access is not case sensitive and you can always display your values in UPPERCASE only if that is what you want.