Dear All,

I have a module that carries out various end of month procedures for
me, part of this includes printing a number of reports. Because some of

the reports are external I need to print them on headed paper in a
seperate tray from the blank A4 paper. Is there a way to instruct the
printer from within my module to use the approipriate trays, for
example, the headed A4 is tray 4 (printerCaps class advises that it's
been assigned the value 256 which I think may be a problem in and of
itself). I'm using an HP 5100dtn and Access 2003 on an XP SP2, could
any of this have a bearing on how the instrutions are being
interpreted?

TIA

Andy

DoCmd.OpenReport "DD/SO - Cover Letter", , , , acHidden
With Reports("DD/SO - Cover Letter").Printer
.PaperBin = 11
End With