Question on Report Height

  • Thread starter Thread starter John Lane
  • Start date Start date
J

John Lane

Is there a way to know, when the Page footer fires, the total height of the
report page up to the bottom of the last detail line when there are multiple
goup headers or footers? Thanks.
 
John said:
Is there a way to know, when the Page footer fires, the total height of the
report page up to the bottom of the last detail line when there are multiple
goup headers or footers?
Click to expand...


Add a module level variable to the report's module. Then
use the detail section's Print event to set the varible:
lngDetailBotttom = Me.Top + Me.Height

Then the Page event can use the variable as the page
position to draw a line or whatever.

FYI, the report (not section) property,Top, provides the
current section's position on the page. In the Print event
the report's Height property provides the current section's
Height after it has grown/shrunk.
 
Marshall Barton said:
Add a module level variable to the report's module. Then
use the detail section's Print event to set the varible:
lngDetailBotttom = Me.Top + Me.Height

Then the Page event can use the variable as the page
position to draw a line or whatever.

FYI, the report (not section) property,Top, provides the
current section's position on the page. In the Print event
the report's Height property provides the current section's
Height after it has grown/shrunk.
Click to expand...

Almost works. I think the multiple group footer breaks are confusing it and
pushing the height. I'm trying to draw a line right under that last detail
line that meets the vertical line. I am using a Page Footer line now but
sometimes, depending on how many group breaks there, pushes it down.
 
John said:
Almost works. I think the multiple group footer breaks are confusing it and
pushing the height. I'm trying to draw a line right under that last detail
line that meets the vertical line. I am using a Page Footer line now but
sometimes, depending on how many group breaks there, pushes it down.
Click to expand...


"Amost works" contains no information about what actually
happens.

I suspect that the report's top margin needs to be included
in the calculation. I can never remember if the margin
needs to be added or subtracted. Try drawing the line
something like:

Me.Line(X, lngDetailBotttom +/- yourtopmarginininches *
1440) - Step(L, 0)
 
Back
Top