title: MS Access Print Report using VBA
body: <p>I have a very VBA intensive report. When I preview it everything is great but when I print it after previewing things go wacky. I have spent many hours narrowing down the possibilities and I have conclude with a certain level of confidence that it is a bug in MS Access.</p>
  
  <p>Up to this point my method for printing reports was to open the report using <code>docmd.openreport "report"</code>. I then use the <code>docmd.printout</code> command so that I can set the page range, collation etc.</p>
  
  <p>Is there a way to print a report directly and still be able to set options like page rage, collate etc without doing a preview first?</p>
  
  <p>Thanks,
  Jeff</p>