Height of content in a report

[entonne]

How would one calculate the height of the content on a page of a report? For example, I have a report that has grouping set to keep together, thus the height of the content on each page differs, I've been trying and trying and searching and searching and I can't seem to figure it out.
Thanks in advance!

 

[BoxHead]

You can get the height of a growing/shrinking textbox on the Detail's OnPrint Event.

I put a textbox [tHt2] on my report and coded:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

tHt2 = txtAcc.Height

End Sub

Oddly enough, setting the textbox Running Sum property did not total it for the detail or the report, but adding another textbox with its controlsource set to

= [tHt2]

and then setting its running sum property does work for getting the group height or the report height.

HTH



John

Use what you have,
Learn what you can,
Create what you need.