A family of Microsoft relational database management systems designed for ease of use.
You shouldn’t need page break controls in your report design. You can set page breaks after in the Grouping properties of the report.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have a report that is based on a select query. The select query does not return any blank records. The report has page breaks at each change in product so that all information for each product is grouped together. When the report is opened in print preview and/or is printed, the first page always contains the report header and footer but no product information. The product information always starts on the second page. How do I get the blank page to stop showing up on the print preview and when it is printed?
A family of Microsoft relational database management systems designed for ease of use.
You shouldn’t need page break controls in your report design. You can set page breaks after in the Grouping properties of the report.
Can you show us the report in design view? Are you using the grouping and sorting feature in your report? What happens if you take out the page break?
The blank first page is almost always caused by the report body (its controls) extending beyond the printable page width or by an unnecessary page break at the top of the report.
Use these checks in Design/Layout view:
Once all controls are within the defined page width and any unnecessary page breaks at the top are removed, the report header and the first product’s data should appear together on page 1, and the blank first page will no longer be printed.
References: