Discussion Locked

unwanted page break in Access report

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a report by X. For each value of X there is the name of X followed by a continuous subform, matched by child/master to X. For some values of X there is an unspecifed page break before the subform information. I can see no pattern - this even happens for one value with an empty subform.

I have this problem with two reports, with different X and different subforms. There seems to be no parallelism between the two errors. Where should I look?

5 replies

by john_wills

Can Grow Yes for subform
Force New Page None in group header - I sort by X.
This happens only for some values of X, 3 out of 6 in one report and 5 out of 40 in the other. There ought to be some relevant difference for different values of X.

by john_wills

The nice people at Compaq Software Support - to whom also I had submitted this problem - tell me that the page skips to keep the entire subform on the same page, and I can't keep the heading together with the details because the details are in the subform. So I have copied the subform query and controls into a new version of the main report and now things work. But I would like to have been able to keep the subform, so I am still open to advice.

This discussion is closed to new replies.