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

ID: Q202238

The information in this article applies to:
  • Microsoft Access 2000
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and 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 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 this to be a problem in the Microsoft products 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.


    11. 
   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 discussed in this article are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

Additional query words: pra rows

Keywords : kbprint kbdta PtrProb RptLabel
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: November 16, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.