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


The information in this article applies to:

  • Microsoft Access 2000
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

  1. Install the HP DeskJet 694C printer driver and make it the default printer.
  2. In Microsoft Access, open the sample database Northwind.mdb.
  3. In the Database window, click Reports under Objects, and then click New.
  4. 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.
  5. In the Filter by manufacturer list, select Avery.
  6. Under Unit of Measure, click English.
  7. In the What label size would you like list, select 5160.
  8. Click Next.
  9. Leave the font and color at the default settings, and click Next again.
  10. 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.
       ContactName
   ContactTitle
   Address
   City, Region PostalCode
  11. Click Next.
  12. In the Which fields do you want to sort by screen of the wizard, click Next.
  13. Click Finish.
Note that in print preview, there are nine rows of labels. There should be ten rows of labels.

REFERENCES

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug kbnofix kbprint KB202238
©2004 Microsoft Corporation. All rights reserved.