Printer.DataOnly Property

  • Article
Access Developer Reference

True if Microsoft Access prints only the data from a table or query in Datasheet View and not the labels, control borders, gridlines, and display graphics. Read/write Boolean.

Syntax

expression.DataOnly

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
   <strong class="bterm"> .DataOnly</strong> = 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