Access 2007 FAQ
How do I get my address field to show up in the Label Wizard in Access 2007?
When I go through the wizard, and when it comes to selecting the field's from the "Available Fields" box, the address field is not there, everything else is. How do I get the address field to appear in this list, so that I can choose it?
On the Reports group of the Create Ribbon tab, there is a button called Labels. This button launches a wizard to assist you with creating a report to make mailing labels. You run the wizard against a table in your database and notice that the Address field is not shown as one of the fields to select for the report, as seen in the following screenshot.
In order for the wizard to pick up your Address field in the Label Wizard dialog, you need to set the data type of the field in the underlying table to Text. If you have a field defined as a Memo data type, the Label Wizard won't pick it up. In the example screenshot below, the Address field is defined as a Memo field, which means the wizard won't pick it up.
In Table Design view, change this field to a text field and then save the changes. The next time you run the wizard, you can select the Address field from the wizard.
See more tips and tricks like this in our book: Microsoft Office Access 2007 Inside Out
Back to FAQ main page