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
|
|||
|
|||
how to force upper case?
Hello
I need to figure out how to force text fields entered via form to uppercase. I have used the input mask '' and won't even allow me to enter data into that field after I make that design change. I would like all of my text box fields to show and store uppercase only. -- Pat Dools |
#2
|
|||
|
|||
Access can't do that inherently.
You can *display* upper case by placing into the Format property of your fields. However, this does not force it to store uppercase, as you will see if you then merge the text out to Word. Setting the Format property like that also has the side effect of truncating all memo fields to 255 characters. The only way to force it to store upper case is to use the AfterUpdate event of each text box on each form to UCase() the entry. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Pat Dools" wrote in message ... Hello I need to figure out how to force text fields entered via form to uppercase. I have used the input mask '' and won't even allow me to enter data into that field after I make that design change. I would like all of my text box fields to show and store uppercase only. -- Pat Dools |
#3
|
|||
|
|||
Pat,
I'd like to suggest that you learn how to use the Microsoft Knowledge Base (KB) to find answers to these types of questions. For example, if I head on over to: http://support.microsoft.com/search/?adv=1&spid=1265 for Access 2000, and enter the search term: Uppercase with a filtered search and full text, the very first hit that I find is this: ACC2000: How to Ensure That Data Is Saved and Displayed in Uppercase http://support.microsoft.com/?id=209520 You might want to bookmark the following URL's, and give them similar names so that you can sort them in a list. I suggest using an underscore, so that they'll sort at the top of the list. _KB Search (Access 97) http://support.microsoft.com/search/?adv=1&spid=1269 _KB Search (Access 2000) http://support.microsoft.com/search/?adv=1&spid=1265 _KB Search (Access 2002) http://support.microsoft.com/search/?adv=1&spid=1266 _KB Search (Access 2003) http://support.microsoft.com/search/?adv=1&spid=2509 Tom _________________________________ "Pat Dools" wrote in message ... Hello I need to figure out how to force text fields entered via form to uppercase. I have used the input mask '' and won't even allow me to enter data into that field after I make that design change. I would like all of my text box fields to show and store uppercase only. -- Pat Dools |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using Validation to force entry into cells? | Mark | General Discussion | 16 | October 27th, 2004 09:23 PM |
How do I distinguish between upper and lower case with pivot tabl. | Fielding | General Discussion | 1 | September 15th, 2004 01:00 PM |
All UPPER CASE to Upper & Lower Case | DDM | Worksheet Functions | 1 | May 8th, 2004 09:04 PM |
Grams to Pounds | Grams to Pounds | Worksheet Functions | 10 | December 12th, 2003 07:32 PM |