Printing a Report from a button using Code Builder

[liamfrancis2013]

I want to print my Report by using Code Builder, from a button, i want this report to fit to one page and be landscape. Anyone know the code for this?

Currently on my button i have the code:

Private Sub Command25_Click()
DoCmd.PrintOut
End Sub

This obviously just prints it landscape and across multiple pages.

Thanks,

[ranman256]

YOU dont need to write any code....turn on the wizard, then grab a button , put it on the form
the wizard will ask:
what action, choose report
pick your report
choose either TO PRINTER, or PREVIEW

done.

[June7]

If you want one page, report must be designed to fit on one page.