Report subform row height

[Kass]

Hi! I have a report that contains a subform that shows up in datasheet view.
I need the row height of the datasheet subform to expand and contract
according to the amount of data contained. If I manually expand the row
height to match the most data in a particular record, it makes all the
records expand accordingly and I have alot of waisted space. If there a way
to have each row height expand and contract to match the data in that row
only.... so it won't look like a uniform table, but that is okay. I'm trying
to conserve space. I've tried the CanGrow and CanShrink and Vertical
Scrollbars formatting for the subform (and report therein).

Thanks!

Kass

 

[Marshall Barton]

Hi! I have a report that contains a subform that shows up in datasheet view.
I need the row height of the datasheet subform to expand and contract
according to the amount of data contained. If I manually expand the row
height to match the most data in a particular record, it makes all the
records expand accordingly and I have alot of waisted space. If there a way
to have each row height expand and contract to match the data in that row
only.... so it won't look like a uniform table, but that is okay. I'm trying
to conserve space. I've tried the CanGrow and CanShrink and Vertical
Scrollbars formatting for the subform (and report therein).

If you would use a subreport instead of a subform, CanGrow
will do it.