CAN GROW but doesn't!

[jflachman]

I have seen this on both forms and reports. Here is are two specific examples:
1) I have a report with a text box that is bound to a function. The function returns a string that contains one or several items separated by VbCrLf's. If that text box is placed in the Page Header, the field doesn't grow to show more than the first line. If that box is placed in the report header it does grow. No changes, a simple copy and paste from one header to the other.

2) I have a form with a text box linked to a memo field. The CanGrow property is set to True in design view. It doesn't matter whether I view the form in Single or Continuous form view. The box doesn't grow to accomodate the entire memo field, it stays at the minimum size set in design view. As workaround, I tried making the box large and setting the CanShrink property to true (also in design view) but it also doesn't shrink.

Any help would be appreciated, thanks. Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt

 

[hsitz]

Don't know about your example (1).

But for example (2) I think the explanation is just that can grow doesn't work for forms unless they're being printed as part of a report. The onscreen view will be unaffected by can grow/can shrink. -- Herb