Table of contents
TOC
Collapse the table of content
Expand the table of content

Printer.PaperSize Property (Access)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Returns or sets an AcPrintPaperSize constant indicating the paper size to use when printing. Read/write.

Syntax

expression. PaperSize

expression A variable that represents a Printer object.

Example

The following example sets a variety of printer settings for the form specified in the strFormname argument of the procedure.

Sub SetPrinter(strFormname As String) 

 DoCmd.OpenForm FormName:=strFormname, view:=acDesign, _ 
 datamode:=acFormEdit, windowmode:=acHidden 

 With Forms(form1).Printer 

 .TopMargin = 1440 
 .BottomMargin = 1440 
 .LeftMargin = 1440 
 .RightMargin = 1440 

 .ColumnSpacing = 360 
 .RowSpacing = 360 

 .ColorMode = acPRCMColor 
 .DataOnly = False 
 .DefaultSize = False 
 .ItemSizeHeight = 2880 
 .ItemSizeWidth = 2880 
 .ItemLayout = acPRVerticalColumnLayout 
 .ItemsAcross = 6 

 .Copies = 1 
 .Orientation = acPRORLandscape 
 .Duplex = acPRDPVertical 
 .PaperBin = acPRBNAuto 
  .PaperSize = acPRPSLetter 
 .PrintQuality = acPRPQMedium 

 End With 

 DoCmd.Close objecttype:=acForm, objectname:=strFormname, _ 
 Save:=acSaveYes 


End Sub

See also

Concepts

Printer Object

© 2017 Microsoft