A report has a subform. The subform is set to datasheet view and its
RecordSource is a select query that includes a memo field from the
source table. The memo field's Can Grow property is Yes, and the
subform Detail section's Can Grow property is Yes. The report Detail
section's Can Grow property is also Yes.
When run, the select query's memo field has all the data. However,
when I run the report, the subform does not show all the data in the
memo field. (I can open the suborm separately from the report and
scroll through the memo field to confirm all the data is there.)
I want to be able to have the subform, in datasheet view, to grow so
that it shows all the data in the memo field without me having to
statically assigning the row height. I thought the Can Grow property
would do that. Any suggestions?