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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing lower to upper case issue 1
Lower-Case Characters 2
Formatting cells to only upper case 5
Split form 0
upper case lower case 0
Convert list to UPPER, lower & Proper cases. 21
To change upper to lower case on keyboard and visa versa 2
Validate data but then change the entry to upper case 4

Top