Vertical line stretching accross the detail section

[Guest]

The detail section of my report can grow vertically. I would like vertical
lines to strech with the text boxes from the top of the detail to the bottom.

Please advise.

 

[Rick Brandt]

The detail section of my report can grow vertically. I would like
vertical lines to strech with the text boxes from the top of the
detail to the bottom.

Please advise.

If you want them to extend all the way to the bottom of the section just
make the bottom coordinate very large. Since a line created in the format
event of a section cannot extend beyond the boundaries of that section your
line will always extend to the bottom of the section then stop.

 

[Marshall Barton]

If you want them to extend all the way to the bottom of the section just
make the bottom coordinate very large. Since a line created in the format
event of a section cannot extend beyond the boundaries of that section your
line will always extend to the bottom of the section then stop.

Right, but the code must be in the Print event procedure.
The section hasn't grown by the time of the Format event.

 

[Rick Brandt]

Right, but the code must be in the Print event procedure.
The section hasn't grown by the time of the Format event.

Both worked the same in my tests.

 

[Marshall Barton]

Both worked the same in my tests.

That's twice today that I've misread a reply. Sorry about
any confusion/wasted effort I may have caused.

I was thinking of the section's Height not being available
in the Format event, but that wasn't the question.

While revisiting this whole issue, I did run across
something interesting(?). In a test report, I had a detail
section text box with the expression =Report.Height that
displayed the final .Height of the detail section. BUT,
when I added a line of code to the Format event that
referenced the text box, the text box displayed the design
..Height.

Looks to me like a line of VBA code that uses the text box
value in the Format event prevents the text box expression
from being reevaluated during the Print phase!?

Not that anyone would really care, but I had no idea that
VBA could have such an influence on the control expression
evaluation process.