VB Code:
  1. Private Sub cmdPrnt_Click()
  2.   If Combo1.Text = "" Then
  3.         MsgBox "Please select an account to print", vbExclamation, "Warning"
  4.     Else
  5.         Set rsDis1 = New ADODB.Recordset
  6.         Set rsDis1 = cn.Execute("select * from checktable where chkname = '" & Combo1.Text & "' ")
  7.         Set rptCheck.DataSource = rsDis1
  8.         rptCheck.Sections("Section4").Controls("lblAccount").Caption = UCase("***" & rsDis1.Fields("chkname").Value & "***")
  9.         rptCheck.Sections("Section2").Controls("lblDate").Caption = UCase(rsDis1.Fields("chkdate").Value)
  10.         rptCheck.Sections("Section4").Controls("lblTotal").Caption = rsDis1.Fields("chkTotal").Value
  11.         rptCheck.Sections("Section4").Controls("lblNum2Wrd").Caption = UCase(rsDis1.Fields("chknumtoword").Value)
  12.         rptCheck.Refresh
  13.         'DataReport1.Show
  14.         rptCheck.PrintReport
  15.         rsDis1.Close
  16.         Unload Me
  17.         frmSplash.Show
  18.     End If
  19. End Sub

i have this code.. how can i set the default printer to be the paper size of A3 or something that i want to.. how can i add it do the code? thanks!