Change all lower case entries to upper case

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

Guest

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.
 
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
 
Back
Top