Address Labels

[TW]

I am trying to create address labels in Access 2007, but when I go into the
label wizard the Address field is not in the list of available fields.
State, ZIP, Country, etc are all there but not street address. How can I get
this field to appear in the available field list?

 

[NetworkTrade]

one presumes that it is in the record source

if your record source is the table itself....try a sanity check and whip up
a query with the same fields...then re-source the label/report to this new
query and check....

 

[TW]

This didn't help - I was able to create a query including the address field,
but when I tried to use the query report as the new record source address
had again disappeared from the list of available fields......

 

[John W. Vinson]

I am trying to create address labels in Access 2007, but when I go into the
label wizard the Address field is not in the list of available fields.
State, ZIP, Country, etc are all there but not street address. How can I get
this field to appear in the available field list?

The wizards aren't all that bright sometimes.

But they are also not essential.

Try using the wizard to create the basic Report; open the report in design
view, and check its Recordsource property. If it's a query which does not
contain your address field, just add that field to the query and save it, then
add the newly defined field to the report using the toolbar.