Adjust the height of a line automatically

[Guest]

Hi,

I have a report in Access, and I would like to delimit each colums by a
vertical line. The problem is that in my detail section I have an memo field
which is set to automatically increase its length as the memo content grows.
Then, the height of each record vary from record to record. When I draw a
vertical line in the detail section, its height is fixed and does not enlarge
with the record. There as to be a way to do such a thing.

Thanks.

 

[Rick Brandt]

Hi,

I have a report in Access, and I would like to delimit each colums by a
vertical line. The problem is that in my detail section I have an memo field
which is set to automatically increase its length as the memo content grows.
Then, the height of each record vary from record to record. When I draw a
vertical line in the detail section, its height is fixed and does not enlarge
with the record. There as to be a way to do such a thing.

Thanks.

You can draw a line using the line method of the report in the format event of
the section you want the line in. One behavior of this is that you cannot draw
a line that extends outside of the section where you are drawing the line so if
you just specify a very large number for the bottom coordinate the line will
always extend to the bottom of the section as it grows and shrinks.

 

[Marshall Barton]

You can draw a line using the line method of the report in the format event of
the section you want the line in. One behavior of this is that you cannot draw
a line that extends outside of the section where you are drawing the line so if
you just specify a very large number for the bottom coordinate the line will
always extend to the bottom of the section as it grows and shrinks.

Whoops. That would be the Print event (after the section's
height has been established).

 

[Rick Brandt]

Whoops. That would be the Print event (after the section's
height has been established).

You only need to use the print event if you want to control the line length with
respect to the "grown" height of the section. If you just want the line to
extend all the way to the bottom of the section regardless of its height then
the format event works just fine. You just use a bottom coordinate that is
guaranteed to reach past the bottom.

 

[Marshall Barton]

Well, I'll be dipped. I've had so much trouble with CanGrow
and the Format event that I just always used the Print
event.

Thanks for straightening me out, Rick.