I have a project where one of my reports is a terms and conditions
statement that is three pages long. To make that report I'm using the
maximum report space, leaving the lower right coner of report space
blank. When I preview it uning the following code, I get the first
three pages and a lower right corner of report space as a blank blank
page.

stDocName = "rptTermsAndCondt"
strWhere = "[ID] = " & Me.[ID]
DoCmd.OpenReport stDocName, acPreview, , strWhere

I can print only the desired pages using the DoCmd.PrintOut command,
but can't find a similiar command for Print Preview.

How can I preview without the fourth page?

I don't think that it's possible to preview only 3 pages. As a kluge, you
might create another report which only has the first 3 pages. You may have
to disable the Print command from the menu bar and command buttons.

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access Solutions", published by Wiley


<rbergman (AT) bellsouth (DOT) net> wrote