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

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

Guest

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?
 
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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COMBO BOX vs Uppercase 6
upper case lower case 0
Uppercase notation in access 2007 3
force uppercase 4
force inputbox to uppercase 2
forcing uppercase 2
Mailing labels: space between state & zip code 3
email addresses on server are uppercase on workstation is in lower 1

Back
Top