I want to print stickers and be able to select the paperbin. When I use a printer with a paperbin value of <255 it seems to work, but unfortunately some of my printers have bin a value > 255, i.e. 261 and this simply seems to be rejected and the default bin (xx=263) is used. Here is the code:
strReport = "rptStickers"
DoCmd.OpenReport strReport, acViewPreview, , , acHidden
With Reports(strReport)
Set .Printer = Application.Printers(cboPrinters.Column(0))
End With
With Reports(strReport).Printer
.PaperBin = cboBins.Column(1)
xx = .PaperBin
Stop
end with
the xx is for debug purposes to let me know what bin the printer has decided to use.
I am using Access 2002, Has anyone else experienced this ?
strReport = "rptStickers"
DoCmd.OpenReport strReport, acViewPreview, , , acHidden
With Reports(strReport)
Set .Printer = Application.Printers(cboPrinters.Column(0))
End With
With Reports(strReport).Printer
.PaperBin = cboBins.Column(1)
xx = .PaperBin
Stop
end with
the xx is for debug purposes to let me know what bin the printer has decided to use.
I am using Access 2002, Has anyone else experienced this ?