ItemsAcross Property

Microsoft Access Visual Basic

ItemsAcross Property

       

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

expression.ItemsAcross

expression   Required. An expression that returns one of the objects in the Applies To list.

Example

The following example sets a variety of printer settings for the first form in the current project.

With Forms(0).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