Can Grow not working!

[tkpstock]

I have a main form with a subform (subform display is continuous forms and key field is linked to key field of main form). I have a text field (enabled, not locked) on the subform that I've set the Can Grow property to Yes, but it doesn't get bigger even though the text! I've set the detail section Can Grow to yes as well. Any thoughts?

 

[FoFa]

How about the multi-line text box property?
Or am I thinking of something else?

 

[tkpstock]

How about the multi-line text box property?
Or am I thinking of something else?

That is a property in VB textboxes, but not in Access textboxes, apparently.

 

[Jerry Stoner]

For Auto Grow to work the text box cannot be touching any other control. That may be your problem

 

[Rich]

CanGrow applies only when printing

 

[Jerry Stoner]

Not true Rich, I use it on reports all the time in preview. To be sure I just tried it out also.

 

[Rich]

we are discussing a form here, not a Report

 

[Bat17]

from help

Notes

The CanGrow and CanShrink properties don't apply to form or report page header and page footer sections, although they do apply to controls in such sections.


These properties affect the display of form sections and controls only when the form is printed or previewed, not when the form is displayed in Form view, Datasheet view, or Design view.

Peter

 

[Jerry Stoner]

Maybe I should READ the post before answering, ya got me

 

[tkpstock]

Thanks Peter - I couldn't find the CanGrow property in the help - i was looking in Access help instead of vba help.

Is there no other way to do it? Like code in an event in the details section to resize the field based on the size of its content?

 

[Bat17]

you can control the size of a text box by code, but, on a continuous subform it would resize each record not just an individual one.

Peter

 

[LemonBirdy]

For Auto Grow to work the text box cannot be touching any other control. That may be your problem

THANK YOU!! That is exactly the answer for which I've been looking for the past month!

 

[Bizmantools]

Late addition on the same subject - I just had a text box that refused to grow until I realised I had it formatted as a number.
Just cleared the formatting and all came right.