ACC2: Mailing Label Wizard Creates One-Page Report
ID: Q115124
|
The information in this article applies to:
SYMPTOMS
Novice: Requires knowledge of the user interface on single-user computers.
A mailing label report created with the Mailing Label Wizard contains only
one page, no matter how many records are in the underlying table or query.
This problem occurs if your default printer is a laser printer, and you
are using any of the following Avery mailing labels:
4145, 4162, 4163, 4249, 4250, 4251, 4253, or 4254
If your default printer is a dot-matrix printer, most mailing label reports
using one-up continuous labels will contain only one page.
CAUSE
This problem occurs if you use the Row Spacing setting in the Print Setup
dialog box to reserve the space between each record or label.
This problem also occurs with reports converted from Microsoft Access
version 1.x if the Row Spacing setting is used.
RESOLUTION
If you set Row Spacing to 0, the report can preview/print all data. To set
Row Spacing, from the File menu, choose Print Setup, click the More
button, set Row Spacing to 0, and then click OK.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access version
2.0. This problem no longer occurs in Microsoft Access version 7.0.
MORE INFORMATION
Steps to Reproduce Problem
- Open the sample database NWIND.MDB.
- Create a new report based on the Customers table. Choose the Report
Wizards button.
- Select the Mailing Label Wizard, and then choose OK.
- In the Available Fields box, select Contact Name, and then choose the
">" button. Choose Next.
- Repeat step 4.
- In the "What label size do you want?" box, select any of the
following labels:
4145, 4162, 4163, 4249, 4250, 4251, 4253, or 4254
- Under Label Type, select Continuous, and then choose Next.
- Choose Next, and then choose Finish. Note that the mailing label report
that is created contains only one page.
REFERENCES
For more information about creating mailing label reports, search for
"creating mailing labels" then select a topic using the Microsoft Access
Help menu.
For more information about how to print to dot matrix printers, please see
the following article in the Microsoft Knowledge Base:
Q103433 ACC: Creating Mailing Labels for Dot-Matrix Printers
Additional query words:
stop
Keywords : kbusage RptWizlbl
Version : 2.0
Platform : WINDOWS
Issue type : kbbug