Vertical line stretching accross the detail section

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Beverly76 said:
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.
Click to expand...

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.
 
Rick said:
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.
Click to expand...


Right, but the code must be in the Print event procedure.
The section hasn't grown by the time of the Format event.
 
Marshall said:
Right, but the code must be in the Print event procedure.
The section hasn't grown by the time of the Format event.
Click to expand...

Both worked the same in my tests.
 
Rick said:
Both worked the same in my tests.
Click to expand...


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.
 
Back
Top