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.

Unanswered: [RESOLVED] Changing lowercase to uppercase

Greetings:

I use the following vba code in an access 2000 database to change lowercase text to uppercase. It is applied to the “Lost Focus” event on each textbox. Is there a simpler way to achieve the same results w/o having to repeat the code so many times?
Thanks in advance

.Value is valid for any textbox control. Although I ususally work in Access 2000 I was using ver 2003 yesterday when I tested this code. Copy and paste back your code here so we can look at it, and explain what exactly what is happening, i.e. the text isn't being changed to upper case or are you getting an error message?

Hope this helps!

The problem with making anything foolproof...is that fools are so darn ingenious!

Don't know what to tell you, Mickey! Your coed looks identical! Code still works here in Access 2000! As I said previously, you won't see the conversion until you save the record, i.e. until you, say, go to another record and then come back. You haven't mentioned any error messages. Your references have to be OK because you were already using UCase successfully. You might want to take a look at the table itself to see if the data has been converted to uppercase there. What kind of form is this;continuous/datasheet/single view? Not a subform, is it?

Hope this helps!

The problem with making anything foolproof...is that fools are so darn ingenious!