how to force upper case?

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

Guest

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.
 
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.
 
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
_________________________________


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