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.
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:
103433 ACC: Creating Mailing Labels for Dot-Matrix Printers
Additional query words: stop
Keywords: kbbug kbusage KB115124