Can Grow isn't growing

[Rowen]

I have a report with a text box where the can grow setting is set to yes, however when I preview the report the text is truncated. Does anyone know how I can fix this so that the whole text appears in the report?

 

[HiTechCoach]

Do you also have the section where the text box is located set to can grow = yes.


Is the data coming form a memo field? If yes, is it getting truncated to 255 characters? If yes, it is probably caused by your query, not the report.

 

[Rowen]

The section of the report is also set to can grow = yes,

I've had a look and it is a memo field, however there's another report that uses the same information but from a different query and the information isn't truncated in that. I've had a look at the two queries and I can't see any real difference between them, though I'm not sure what I should be looking for?

 

[HiTechCoach]

There are several things that can cause this.

See:
Truncation of Memo fields

 

[Rowen]

Ah-ha, Thanks for the link, it didn't quite fix the problem, as following the solution for the Group By didn't stop the field from being truncated, however I ended up removing the group by for the whole query and that did solve the problem. So thanks for the help.

 

[HiTechCoach]

You're welcome!

Glad we could assist.