Microsoft KB Archive/115124

= ACC2: Mailing Label Wizard Creates One-Page Report =

Article ID: 115124

Article Last Modified on 6/25/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q115124



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
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.



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.</li> Repeat step 4.</li>  In the "What label size do you want?" box, select any of the following labels:

<pre class="fixed_text">     4145, 4162, 4163, 4249, 4250, 4251, 4253, or 4254 </li> Under Label Type, select Continuous, and then choose Next.</li> Choose Next, and then choose Finish. Note that the mailing label report that is created contains only one page.</li></ol>

<div class="references_section">