I am creating an access report with sub-reports with data in the details section. There are too many rows of data to fit on the page when printing the report, so a page break happens automatically. (I want the page break to happen, that's not the problem.)
My problem is that the last row on the page is being stretched to fill the page vertically. I would like it to be the same height as the other rows.
Is there a property that controls weather or not the last line of detail will stretch to the bottom of the page or not? Or is this intended (to show the reader that the data continues on the next page)?
I have tried setting the following properties of the Detail Section in my sub report: Can Grow, Can Shrink and Auto Height. I have also tried the Fit To Page property of the sub report itself within the report. But I still get a slightly taller last line at the bottom of the page.
Maybe I'm not googling the right words, I'm new to MS Access and access reports. I use Microsoft® Access® for Microsoft 365.