I need help controling a line

[Al]

I am trying to make a line that can grow and shrink up
till the bottom of the Detail section of a report only. I
am using the following line of code to draw the line that
can grow and shrink with the report:

Me.Line (0.852 * 1440, 1180)-(0.852 * 1440, 11000)

The problem with this approach is that I have a report
printed with different filters which, sometimes, make the
detail section shorter or longer. Since the line is
growing through out the report (header, detail, and
footer), it will be on the entire page (header, detail,
and footer) even though, that sometimes half of the page,
only, has data and the rest is blank. Is there a way to
make the line grow or shrink based on the bottom of the
detail section only not the entire page. I tried to use
the following but it did not work:

Me.Line (0 * 1440, Me.Line1.Top)-(0 * 1440, 4400 +
Me.Detail.Height)

Where 4400 = the distance from Line1 to the bottom of the
page Header .
When I used me.pageheader.height + Me.Detail.Height, I got
Unidentified qualifier on the PageHeader?
Any idea
Thanks
Al

 

[Marshall Barton]

I am trying to make a line that can grow and shrink up
till the bottom of the Detail section of a report only. I
am using the following line of code to draw the line that
can grow and shrink with the report:

Me.Line (0.852 * 1440, 1180)-(0.852 * 1440, 11000)

The problem with this approach is that I have a report
printed with different filters which, sometimes, make the
detail section shorter or longer. Since the line is
growing through out the report (header, detail, and
footer), it will be on the entire page (header, detail,
and footer) even though, that sometimes half of the page,
only, has data and the rest is blank. Is there a way to
make the line grow or shrink based on the bottom of the
detail section only not the entire page. I tried to use
the following but it did not work:

Me.Line (0 * 1440, Me.Line1.Top)-(0 * 1440, 4400 +
Me.Detail.Height)

Where 4400 = the distance from Line1 to the bottom of the
page Header .
When I used me.pageheader.height + Me.Detail.Height, I got
Unidentified qualifier on the PageHeader?

The big question here is where is that line of code?

It sounds like you have it in the report's Page event, which
draws aon the entire page.

I think you want it in the detail section's Print event
where you don't need to know where the details are on the
page, just draw a very long line from the top of the detail
(it will be cropped at the bottom of the section.

Me.Line (0.852 * 1440, 0)-Step(0, 20000)

 

[Al]

You are right.
thank you
Al

-----Original Message-----



The big question here is where is that line of code?

It sounds like you have it in the report's Page event, which
draws aon the entire page.

I think you want it in the detail section's Print event
where you don't need to know where the details are on the
page, just draw a very long line from the top of the detail
(it will be cropped at the bottom of the section.

Me.Line (0.852 * 1440, 0)-Step(0, 20000)