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]

Turn on the wizard, then drop a button on the form,
the wizard will ask you...
select rreport.
select which report.
select printer, or preview.

but the code is...
docmd.openreport "rMyRpt", acpreview

[liamfrancis2013]

Thanks them solutions were brilliant, i did end up using the code though because my buttons are on my report, and the control wizard didn't work on them

[ranman256]

you must turn on the wizard. it does work.