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.
| Property | Data Type | Description |
|---|---|---|
| BottomMargin | Long | Bottom margin for the printed page. |
| ColorMode | AcPrintColor Enum | Whether the printer should output in color or monochrome mode. |
| ColumnSpacing | Long | Vertical space between detail sections (in twips). |
| Copies | Long | Number of copies to be printed. |
| Dataonly | Boolean | True if Access prints only the data and not the labels, borders, gridlines, and graphics. |
| DefaultSize | Boolean | True when the size of the detail section in design view is used for printing. False if the ItemSizeHeight and ItemSizeWidth properties are used. |
| DeviceName | String | Name of the printer. |
| DriverName | String | Name of the driver used by the specified printer. |
| Duplex | AcPrintDuplex Enum | How the printer handles duplex printing. |
| ItemLayout | AcPrintItemLayout Enum | Whether the printer lays out columns across, then down, or down, then across. |
| ItemsAcross | Long | Number of columns to print across a page. |
| ItemSizeHeight | Long | Height of the detail section in twips. |
| ItemSizeWidth | Long | Width of the detail section in twips. |
| LeftMargin | Long | Left margin for the printed page. |
| Orientation | AcPrintOrientation Enum | Print orientation. |
| PaperBin | AcPrinterBin Enum | Which paper bin the printer should use. |
| PaperSize ... |
Get Access™ 2007 VBA Programmer's Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
