If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change all lower case entries to upper case
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. |
#2
|
|||
|
|||
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 "Elizabeth" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I change Letter case (lower to Upper) in a spreadsheet??? | mineisjosh | General Discussion | 4 | February 20th, 2005 01:49 AM |
change case | kunalnp_dsfs | General Discussion | 2 | November 11th, 2004 06:42 PM |
Upper case to lower case | betsy | Worksheet Functions | 6 | September 16th, 2003 12:00 AM |