state in mailing label wizard not uppercase when > used in table

D

DeeCeeNJ

Access 2003: I type lowercase states and then format them uppercase by using
as a field property in the table. When I use this table in the Mailing
Click to expand...
Label Wizard, the states are lowercase. I think this is new to 2003. Any
ideas?
 
J

Jeff Boyce

You may wish to confirm that your formatting and your data-as-store are the
same (hint: usually, what is stored and what is displayed are not
necessarily connected).

To solve your current situation you can use the UCase() function in your
query or report to force display of your field(s) to UpperCase.

Good luck

Jeff Boyce
<Access MVP>
 
Top