ACC2: Mailing Label Wizard Creates One-Page Report

Last reviewed: May 23, 1997
Article ID: Q115124
The information in this article applies to:
  • Microsoft Access version 2.0

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

  1. Open the sample database NWIND.MDB.

  2. Create a new report based on the Customers table. Choose the Report Wizards button.

  3. Select the Mailing Label Wizard, and then choose OK.

  4. In the Available Fields box, select Contact Name, and then choose the ">" button. Choose Next.

  5. Repeat step 4.

  6. In the "What label size do you want?" box, select any of the following labels:

          4145, 4162, 4163, 4249, 4250, 4251, 4253, or 4254
    

  7. Under Label Type, select Continuous, and then choose Next.

  8. 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:

   ARTICLE-ID: Q103433
   TITLE     : ACC: Creating Mailing Labels for Dot-Matrix Printers

You can also obtain this article through Microsoft FastTips by ordering item number 103433 from the FastTips Main Menu.


Additional query words: stop
Keywords : kbusage RptWizlbl
Version : 2.0
Platform : WINDOWS
Hardware : X86
Issue type : kbbug
Resolution Type : kbworkaround


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 23, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.