Printing Labels with State not State ID

[Guest]

I have a mailing list - table, where the state field draws from a look up
table(combo box) with the two initial state abbreviation. Each state was give
an id # within this look up box.

As far as I can tell, the db structure seems solid. The forms display the
state abbreviation (MI,) and a query also shows the state abbreviation (MI)

But when I try to run a label report with the Label Wizard. The state # is
displayed not the state abbreivation. (23)

I don't want to confuse our local post office with labels that say Ann
Arbor, 23 49707. Can anyone provide assistance or suggestions?

Thanks!!!
Kris

 

[Duane Hookom]

Read http://www.mvps.org/access/lookupfields.htm.
Do you have a lookup table of the state ID as well as the abbreviation? If
so, include it in the report's recordsource so you can use the abbreviation
field.