Sizing Reports

[Jade]

Hi There,

I was wondering if anyone knows how to have reports open to fit to page. I don't want to have to use the scroll bars to view the page.

Thank you
Jen

 

[Majid Umar]

Try this,

Private Sub ButtonToOpenReport_Click()

DoCmd.OpenReport "Report_Name", acViewPreview, "", ""
DoCmd.RunCommand acCmdFitToWindow

End Sub