Microsoft KB Archive/202238

= ACC2000: Access May Not Print on the Last Row(s) of Labels on a Mailing Label Sheet =

Article ID: 202238

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q202238



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
When you print preview or print your mailing label report, the last row(s) of labels on each page is not used.



CAUSE
This happens if you print to some printers such as the Hewlett-Packard (HP) DeskJet 694C, HP DeskJet 600, HP DeskJet 550C, Canon BJC-4100, Epson Stylus Color 600, and Epson Stylus Color 900.



RESOLUTION
Use one of the following methods to use all the labels on the sheet.

Method 1
Choose a paper size with a longer length, such as A4, and then bypass the "Some data may not be displayed" message by clicking OK.

Method 2
In Design view or Print Preview of the report, click Page Setup on the File menu, click the Margins tab, and decrease the size of the margins. For example, set the Top margin to 0.25", set the Bottom margin to 0.55", and then click OK.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
This behavior does not skip any of the records that you want to print. You just have a blank row of labels at the bottom of the page.

Steps to Reproduce Behavior
 Install the HP DeskJet 694C printer driver and make it the default printer. In Microsoft Access, open the sample database Northwind.mdb. In the Database window, click Reports under Objects, and then click New. Click Label Wizard. In the Choose the table or query where the object's data comes from list, select the Customers table and click OK. In the Filter by manufacturer list, select Avery.</li> Under Unit of Measure, click English.</li> In the What label size would you like list, select 5160.</li> Click Next.</li> Leave the font and color at the default settings, and click Next again.</li>  In the What would you like on your mailing label screen of the wizard, add the following fields to the Prototype label box:

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> Click Next.</li> In the Which fields do you want to sort by screen of the wizard, click Next.</li> Click Finish.</li></ol>

Note that in print preview, there are nine rows of labels. There should be ten rows of labels.

<div class="references_section">