MS Access 2002 - printing Report to specific tray.
Posted on 2004-04-22
I am trying to print a Report (address labels) to a specific tray on a printer with limited success.
The network printer (HP4200) has Tray3 allocated to Labels, but I have been unable to use the tray without receiving a prompt on the printer itself (Source = "Automatically Select" ; Type = "Labels").
Using various combinations of Source and Type also has limited success. Setting the Type to "Labels" overwrites any value selected for "Source" with whatever value was selected via the printer's Printing Preferences (eg "Automatically Select"). Setting the Source to "Tray3" and Type to "Unspecified" does print the labels automaticallly, but from Tray2 on its plain paper.
Any hints/tips/ideas (for the Access report or the printer) would be gratefully received.
PS I have also posted this question to the HP Printer section.