E.18. The Printer Object
Access VBA allows 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.
E.18.1. Printer Object Properties
The properties of the Printer object are listed in the following table.
| Properties | Data Type | Description |
|---|---|---|
| BottomMargin | Long | Specifies the bottom margin for the printed page |
| ColorMode | acPrintColor (acPRCMColor, acPRCMMonochrome) | Specifies whether the printer should output in color or monochrome mode |
| ColumnSpacing | Long | Specifies the vertical space between detail sections (in twips) |
| Copies | Long | Indicates the number of copies to be printed |
| Dataonly | Boolean | True if Access only prints 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 (acPRDPHorizontal, acPRDPSimplex, acPRDPVertical) | Specifies how the printer handles duplex printing |
| ItemLayout | acPrintItemLayout (acPRHorizontalColumnLayout, acPRVerticalColumnLayout) | Specifies whether the printer lays out columns across, then down, or down, then across |
| ItemsAcross | Long | Indicates the number of columns to print across a page |
| ItemSizeHeight | Long | Specifies the height of the detail section in twips |
| ItemSizeWidth ... |
Get Access 2003 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.
