OK I have used automation with Access to export and import database, as well as, compacting a database.

Can someone help me on how to automate the printing of a stored report in Access 2000? To print now, I am currently using VB's "Printer.Print" commands and, with complex reports, it can take hours to get the report just right. I figured if I could create the report in Access, then print from VB, I could save myself some time. Any opinions on this subject?