How to print label in a report?

[Ciro]

How is possible make a report where each field in the detail section is repeated on different columns? I need it to print labels coming from a list of contacts.

Thanks for any feedback.
Ciro

 

[TruthAndBeauty]

labels are "Columnar" reports.

1. In MSAccess use can use the report wizard. After you respond to a couple wizard screens prompts identifying table and field names you will be prompted to choose the layout: columnar, tabular or justified. Sselect columnar and play with it.

2. Another approach is to create a report with the layout of a single label then while you are in the design mode goto FILE/PAGE-Setup and select the Column tab on the dialog box. Enter the number of columns (labels) that will fit across a page. (there are a couple other parameters you can experiment with) save the report and open it. Make any margin, fonts, or other layout adjustment you like.

3. Another method is described when you search on "Avery" in MSAccess Help.


I susggest the user be presented with the print dialog box so they can select the printer and ensure label paper in available before printing.


Keep in mind that each label is a single record/row of data.

Good luck