Still not right on cutting off children

[maggielady]

I have a 3 column report setup like so:
famiy name family name family name
address address address
children children children

the list of children I have in a subreport and placed in the major report with family name and address. the children are listed like this, Joe, Jane, Jack, but if the field goes over 40 characters, the width of the column, it cuts off the rest of the children. I have can grow checked in the format field but it doesn't seem to be working. The children are in a calculated field and I just can't seem to get them to go to the next line in the column. I'm almost there but not quite. Any help , besides the great suggestions I've already gotten and tried, would be GREATLY appreciated!! here is the formula I have for the children:
whileprintingrecords;
stringvar item:={MEMBER.PREF_NAME};
stringvar chain;
numbervar chcnt;

if chcnt=1
then(chcnt:=2;chain:=item)
else
if length(chain)+length(item) >254
then chain:=chain else
chain:=chain+', '+item

 

[stevefah]

Leave "Can Grow" checked and add a chr(10) to your string, like this:

whileprintingrecords;
stringvar item:={MEMBER.PREF_NAME};
stringvar chain;
numbervar chcnt;

if chcnt=1
then(chcnt:=2;chain:=item)
else
if length(chain)+length(item) >254
then chain:=chain else
chain:=chain+', '+chr(10)+item

That will push the next item to the next line.
---Steve