Report field does not grow

[Bob]

I am creating a report which groups steel and plastic components for an
item and prints the those components in two lists. I may have have up
to 25 items associated with the steel or plastic and I am building a
comma separated list in the report from query data. When the report
prints, I get only a single row of data for each component whether or
not it fills more than one row. When I expand the field to multiple
lines and do not allow it to shrink, the data shows for larger list,
but I get blank space on smaller lists. If I allow it to shrink, I get
only 1 row even when there are multiple rows. I have the field set to
can grow and the section, which is in a footer is also set to can grow.
Using a 'dash instead of a comma does not help.

 

[Jeff Boyce]

This strikes me as a "Reports" question, not a "Forms" question...

If your report includes a control to the right of this one, and aligned, the
CanGrow/CanShrink properties get confused by the properties of the control
to the right.

Regards

Jeff Boyce
Microsoft Office/Access MVP