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:
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, and Canon BJC-4100.


RESOLUTION

One workaround is to choose a paper size with a longer length, such as A4, and to ignore the message Some data may not be displayed by clicking OK on the message.


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 here 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: May 13, 1999