Software

Ask something
Discussion Locked

extra page in Access report with filter

0 helpful
8 replies

by john.a.wills

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an Access report which gives a second page, blank except for the footing, when I am filtering for one item but only one page per item (even the last one) when the filter is switched off. The page setting is landscape. The report includes 3 subreports, of which one is near the bottom of the page. It does not seem to matter which item I filter for.

8 replies

by dryflies

you are forcing a page break after one of the groups in your report. most likely the detail page. remove the forced page breaks and then experiemnt with placing the page break before or after each grouping until you find the one you like
Please rate my answer

by john.a.wills

I know what a page break looks like in Design View and I do not appear to have one either in the report itself or in its last subreport.

by john.a.wills

No there isn't: the problem is that the report header and the detail together exceed the page size. Shortening the detail remedies the matter.

by sgt_shultz

steady, fellas...
this is a known problem with Access that i think remember somebody wrote some code to get rid of the extra page. musta been on microsoft downloads or from the ms access support page...it isn't a hard page break it is the 'feature' of access reporting. it thinks you need another page because you have crossed some invisible formatting line. wonder if exporting to word would give you enuf control to take care of this. is this happening on just this report or even on a simple new report you make up to test. how doews the page before the blank page look? is it full. does it have graphics, forumlae and stuff.

by sgt_shultz

could you have records coming out on the report containing blank or null values, maybe sorted so come at the end..

This discussion is closed to new replies.