Microsoft KB Archive/119476

= ACC: Some Labels Skipped in Mailing Label Report =

Article ID: 119476

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q119476



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



SYMPTOMS
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
 Open the sample database Northwind.mdb In the Database window, click the Reports tab, and then click New. 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. In the Label Type box, click Sheet Feed. Select 5164 in the Avery number box, and then click Next. Leave the font and color at the default settings and click Next.</li>  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.

<pre class="fixed_text">      ContactName ContactTitle Address City, Region PostalCode </li> In the "Which fields do you want to sort by?" dialog box, click Next.</li> In the "What name would you like for your report?" dialog box, click Modify the label design, and then click Finish.</li> 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.</li> Preview the report. Note that no labels on the report are skipped.</li> 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.</li> Preview the report. Note that the labels on some pages are skipped.</li></ol>

Steps to Reproduce Behavior in Microsoft Access 2.0
<ol> Open the sample database NWIND.MDB.</li> In the Database window, click the Report tab, and then click New.</li> In the Select A Table/Query box, select the Customers table, and then click the Report Wizards button.</li> In the Which Wizard Do You Want? screen, select Mailing Label and then click OK.</li>  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.

<pre class="fixed_text">      Contact Name Contact Title Address City, Region Postal Code </li> In the "Which fields do you want to sort by?" dialog box, click Next.</li> 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.</li> In the "What font and color do you want?" dialog box, click Next.</li> <li>Click Modify the mailing label design, and then click Finish.</li> <li>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.</li> <li>Preview the report. Note that no labels on the report are skipped.</li> <li>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.</li> <li>Preview the report. Note that the labels on some pages are skipped.</li></ol>

<div class="references_section">