Previewing a report

If you want to preview a report, Access will normally open it up full-size, so that you can't see the whole page at once. If you wish to have your reports opened as large as the screen will allow, then when you open the report add a line of code:

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

http://www.applecore99.com/rpt/rpt008.asp