Change all lower case entries to upper case

E

Elizabeth

I have an Access database I've designed and is ready for deployment, however,
the user wants to be able to enter all data in lower case or however it
appears and have it automatically change to upper case. The data entry forms
have several subforms so I would like to "globally" set the fields to UC
only. Is this possible or must I enter >LLLL into the input mask for each
field? Thanks.
 
C

Chris

Hi Elizabeth

This works for me:

In the after update event for each control you want this to happen put the
following code:

Me![txtLastName] = UCase(Me![txtLastName])

substitute your own control names as required.

Good luck

Chris
 
Top