O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

G.11. The Printer Object

Access VBA enables you to manipulate the printers available on your system through code. All available printers are members of the Printers collection. You can access an individual printer through the Printer object.

G.11.1. Printer Object Properties

The properties of the Printer object are explained in the following table.

PropertyData TypeDescription
BottomMarginLongBottom margin for the printed page.
ColorModeAcPrintColor EnumWhether the printer should output in color or monochrome mode.
ColumnSpacingLongVertical space between detail sections (in twips).
CopiesLongNumber of copies to be printed.
DataonlyBooleanTrue if Access prints only the data and not the labels, borders, gridlines, and graphics.
DefaultSizeBooleanTrue when the size of the detail section in design view is used for printing. False if the ItemSizeHeight and ItemSizeWidth properties are used.
DeviceNameStringName of the printer.
DriverNameStringName of the driver used by the specified printer.
DuplexAcPrintDuplex EnumHow the printer handles duplex printing.
ItemLayoutAcPrintItemLayout EnumWhether the printer lays out columns across, then down, or down, then across.
ItemsAcrossLongNumber of columns to print across a page.
ItemSizeHeightLongHeight of the detail section in twips.
ItemSizeWidthLongWidth of the detail section in twips.
LeftMarginLongLeft margin for the printed page.
OrientationAcPrintOrientation EnumPrint orientation.
PaperBinAcPrinterBin EnumWhich paper bin the printer should use.
PaperSize ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required