Subform Header seperating from details

I have a subform on a report and depending on the amount of data on the main form, the subform header is sometimes fitting on the first page but bumping the details of the subform on the 2nd page.  

Is there a property that I could set on the subform to ensure that the form header stays on the same page as the subform details?  
gcgcitAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
<<Is there a property that I could set on the subform to ensure that the form header stays on the same page as the subform details?   >>

  No.  Only thing you can do is in the OnFormat event see how far down the page you are.  If too far, then make a page break visible.

  Or through the Group header properties, you could just automatically do a page break before the header prints.

JimD.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Could you use a Report for this?

Reports are made for printing and you have much more control over the output...
0
 
gcgcitAuthor Commented:
Sorry it is on a report... I meant to type subreport above.
0
 
gcgcitAuthor Commented:
I have a report with multiple subreports.
0
 
gcgcitAuthor Commented:
Put pagebreak above that subreport.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.