 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2007forcing uppercase
In my forms or tables, I can use the format property to make the data displayed be uppercase, but it is not actually stored that way -- it is stored how it is entered (either upper or lowercase). How do I force the data to be stored as uppercase? Heidi One way might be to use the BeforeUpdate event in your forms to change the value: Me!txtYourTextControl = UCase(Me!txtYourTextControl) Are you aware that once you've converted some types of data, you will have some real headaches ever getting it back? For example, if you store a LastName value, and might ever want to use something like: Dear [LastName] in an Access (or Word) document, you will have problems handling names that started out like: O'Brien MacDonald van de Wigge after you've forced them to all CAPS. Regards Jeff Boyce Microsoft Office/Access MVP > In my forms or tables, I can use the format property to make the data > displayed be uppercase, but it is not actually stored that way -- it is > stored how it is entered (either upper or lowercase). How do I force the > data to be stored as uppercase? Jeff, that is perfect... thank you for the response. I appreciate you giving me the heads up about recovering the data as you explained. > Heidi > [quoted text clipped - 26 lines] > > stored how it is entered (either upper or lowercase). How do I force the > > data to be stored as uppercase? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.