ACC: Some Labels Skipped in Mailing Label Report

• Microsoft Access versions 2.0, 7.0, 97

SYMPTOMS

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

When you print a mailing label report, Microsoft Access skips some of the labels even though all of the records are printed.

CAUSE

This behavior can occur if you set the CanGrow property of the report's detail section and for all the controls in the detail section to Yes.

RESOLUTION

Set the CanGrow property for the detail section, or for one or more of the controls in the detail section, to No.

STATUS

This behavior is by design.

MORE INFORMATION

If the CanGrow property is set to Yes for both the detail section and for all the controls in the detail section, one or more of the labels may grow on some pages. If a label grows, the detail section also grows, forcing some labels to be printed on the next page.

Steps to Reproduce Behavior in Microsoft Access 7.0 and 97

1. Open the sample database Northwind.mdb

2. In the Database window, click the Reports tab, and then click New.

3. In the "Choose the table or query where the object's data comes from" box, select the Customers table, and then click the Label Wizard. Click OK to start the Wizard.

4. In the Label Type box, click Sheet Feed. Select 5164 in the Avery number box, and then click Next.

5. Leave the font and color at the default settings and click Next.

6. In the "What would you like on your mailing label?" dialog box, add the following fields to the Prototype label box, and then click Next:

   NOTE: Press ENTER in the Prototype label box when you want to start a new line.

   ContactName ContactTitle Address City, Region PostalCode

7. In the "Which fields do you want to sort by?" dialog box, click Next.

8. In the "What name would you like for your report?" dialog box, click Modify the label design, and then click Finish.

9. When the report opens in Design view, make sure the CanGrow property for either the detail section or one or more of the controls in the detail section is set to No.

10. Preview the report. Note that no labels on the report are skipped.

11. Open the report in Design view. Set the CanGrow property for the detail section, and for all the controls in the detail section, to Yes.

12. Preview the report. Note that the labels on some pages are skipped.

Steps to Reproduce Behavior in Microsoft Access 2.0

1. Open the sample database NWIND.MDB.

2. In the Database window, click the Report tab, and then click New.

3. In the Select A Table/Query box, select the Customers table, and then click the Report Wizards button.

4. In the Which Wizard Do You Want? screen, select Mailing Label and then click OK.

5. Add the following fields to the Label appearance box, and then click Next:

   NOTE: Click the Newline button when you want to start a new line in the Label appearance box, and click the "," or Space button when you want to add a comma or a space.

   Contact Name Contact Title Address City, Region Postal Code

6. In the "Which fields do you want to sort by?" dialog box, click Next.

7. In the "What label size do you want?" dialog box, click Sheet feed in the Label Type box, select 5164 in the Avery number box, and then click Next.

8. In the "What font and color do you want?" dialog box, click Next.

9. Click Modify the mailing label design, and then click Finish.

10. When the report opens in Design view, make sure the CanGrow property for either the detail section or one or more of the controls in the detail section is set to No.

11. Preview the report. Note that no labels on the report are skipped.

12. Open the report in Design view. Set the CanGrow property for the detail section, and for all the controls in the detail section, to Yes.

13. Preview the report. Note that the labels on some pages are skipped.

REFERENCES