Share via

Printer.ItemsAcross Property

  • Article
Access Developer Reference

Returns or sets a Long indicating the number of columns to print across a page for multiple-column reports or labels. Read/write.

Syntax

expression.ItemsAcross

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.

Visual Basic for Applications 
  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
  <strong class="bterm">  .ItemsAcross</strong> = 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