Upper case using Label Wizard

[Guest]

I have just recently begun using Access 2000 and am not a sophisticated user. I set up a database that has one table (primarily names and addresses). In the form I created for data entry, I chose to have the text automatically change to upper case no matter how it is entered. In the associated table, the text appears in upper case as it should. In a routine report that uses the table, the text prints in upper case as it should. However, when I use the Label Wizard to create mailing labels, the text appears entirely in lower case which is not acceptable. How can this be? It almost seems like a bug. How do I get the labels to print in upper case? Thanks very much for your help
Chuckb

 

[Fons Ponsioen]

Hi Chuck.
It depends how you show all caps as to how it is realy
stored in the table. But anyway.
In the textbox format for your report simply plase a >
this will print all characters in upper case.
An other way would be to let us say that the name for the
data element is CombinedName than you could put in the
source =UCASE([CombinedName]). If you deside to go this
way make sure that the name of the textbox is not the same
as the name of the data element.
Hope this helps.
Fons.

-----Original Message-----
I have just recently begun using Access 2000 and am not a

sophisticated user. I set up a database that has one
table (primarily names and addresses). In the form I
created for data entry, I chose to have the text
automatically change to upper case no matter how it is
entered. In the associated table, the text appears in
upper case as it should. In a routine report that uses
the table, the text prints in upper case as it should.
However, when I use the Label Wizard to create mailing
labels, the text appears entirely in lower case which is
not acceptable. How can this be? It almost seems like a
bug. How do I get the labels to print in upper case?
Thanks very much for your help.