Access - textbox.CanGrow = True and continuous forms

Question

Hi.

From my searching, it appears that a textbox on a continuous form cannot grow to fit text as it can on a report, even if canGrow = True. Is this correct? My subform has two fields: Notes (long text) and a date. I, like many others, would like the textbox containing the note to rightsize to the size of the data.

I saw a thread where you can insert a report into a form and I could insert a report into a form. But I couldn't figure out how to set up the report as a subreport like you do with a form. I mean, set the report so it's a child of the form on some table's field. The report had all the data for each person. What I'd like is the data to be limited to a specific person.

In sum, I can get the filtered data easily with a subform, but the formatting is not there. I can get the formatting done very nicely with a report, but cannot filter the data programmatically.

Does anyone know how to do this?

Answer 1

Hi. I think the Can Grow property on a Form only applies when you're printing the Form. Yes, you should to use a report as a subform, but I also think you can only use in Report View, which may or may not allow the Can Grow property work.