CanGrow Property

[JimP]

I have a text control on a report with the CanGrow property set to yes.

Setting the Control Source property to the name of the field and CanGrow
works (e.g. [CustName])
Setting the Contol Source property to a calculated field truncates it (e.g.
=[CustName])

Is there a way to force the latter to "CanGrow"?

 

[Linq Adams via AccessMonster.com]

I think the problem is that Access has to have the field saved, in memory,
when the Report loads, in order to know how much 'room' to allot to it. With
the Field it has this refence, with a calculated field, done after the Report
loads, it doesn't.

To do this for a calculated field, I think you need to base your Report on a
Query, and have the calculation done in the Query rather than in the Report.
Then your refer to the calculated field, which is available when the Report
loads.