Report Page Breaks with VBA

[JimC]

I have a Report that uses the detail section as a Header and for details.Some of the Details sections only contain"Header" information, some of the Details Section contain "Header" information and Data. I have the "Keep Together" property set to Always, but I need to refine the page breaks I'm getting. I have inserted a Page Break below the Text boxes and Sub-report in my Details Section. I'm able to turn the properties of my Page Break Visible True/False in the On Format Event. I need to know how to measure how much room is left on my Report Page so I can set up a If/Then statement.
Here is what I've goten so far:

Me!PageBreak85.Visible = False
If Report!rptPaneShelf.Windowheight < 950 Then
Me!PageBreak85.Visible = True
End If

950 is the minimum height in Twips

Basically I need to find the height left on the report minus the next Detail section to be greater than 950 Twips(3 possible Details section heights)

 

[geraldcor]

I too am VERY interested in any help with this same question. I have searched all around and have found plenty of questions, but no answers. Thank you all for any help.