ACC2: Mailing Label Wizard Creates One-Page Report

• 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

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