printing label in access 2000

[mikey0143]

I have a problem printing label through report using label wizard. The problem is that I can't seem to print out the city part in a an address. The city is in a (list box). Every time I print the following appears:

John Doe
123 Hill St.
1, MN 55101

The 1 before the MN is actually the auto number in the list box. So, instead of printing the city which is corresponding to the auto number. It just print the auto number.

Can you help..

Fong Xiong

 

[Terpsfan]

The table that you are deriving the address data from is probably using the City field as a look up table. The city table probably has two fields, an autonumber field and a city name field. Go back to the table in design view and then redo the lookup field and point it to the Cityname field, not the autonumber field.