General discussion

Locked

extra page in Access report with filter

By john.a.wills ·
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.

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by dryflies In reply to extra page in Access repo ...

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

Collapse -

by john.a.wills In reply to

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.

Collapse -

by dryflies In reply to extra page in Access repo ...

trust me, there is one there somewhere

Collapse -

by john.a.wills In reply to

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.

Collapse -

by sgt_shultz In reply to extra page in Access repo ...

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.

Collapse -

by sgt_shultz In reply to

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

Collapse -

by john.a.wills In reply to

Please see response to dryflies' second answer.

Collapse -

by john.a.wills In reply to extra page in Access repo ...

This question was closed by the author

Back to Software Forum
8 total posts (Page 1 of 1)  

Related Discussions

Related Forums