How to Get Memo Box to "Can Grow" On A Form

[doyle60]

I have five controls on a form all lined up vertically. The first two
and last two are simple text boxes. But the middle one is a control
with a memo field as its source. It could be rather long or rather
short. So I want to make it pretty short and set the Can Grow
propterty to Yes.

But when I view it in Form View it does not work. It does not grow.

I've done this before. But I don't get what I'm doing wrong here.
Can all five controls be in the Detail section? What could be some
problems? Anyway, how should I do this.

Matt

 

[fredg]

I have five controls on a form all lined up vertically. The first two
and last two are simple text boxes. But the middle one is a control
with a memo field as its source. It could be rather long or rather
short. So I want to make it pretty short and set the Can Grow
propterty to Yes.

But when I view it in Form View it does not work. It does not grow.

I've done this before. But I don't get what I'm doing wrong here.
Can all five controls be in the Detail section? What could be some
problems? Anyway, how should I do this.

Matt

You can't.

From VBA help on CanGrow:

"This property affects 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. "

 

[Rick Brandt]

I have five controls on a form all lined up vertically. The first two
and last two are simple text boxes. But the middle one is a control
with a memo field as its source. It could be rather long or rather
short. So I want to make it pretty short and set the Can Grow
propterty to Yes.

But when I view it in Form View it does not work. It does not grow.

I've done this before. But I don't get what I'm doing wrong here.
Can all five controls be in the Detail section? What could be some
problems? Anyway, how should I do this.

CanGrow (even in forms) only apples to printing, not on-screen viewing. You can
make controls grow in the form resize event so that the control for the memo
field would get taller as you made the form taller (or wider as the form is made
wider), but doing that automaticaly per record in response to the amount of text
would not likely produce a very nice effect.

 

[Marshall Barton]

I have five controls on a form all lined up vertically. The first two
and last two are simple text boxes. But the middle one is a control
with a memo field as its source. It could be rather long or rather
short. So I want to make it pretty short and set the Can Grow
propterty to Yes.

But when I view it in Form View it does not work. It does not grow.

I've done this before. But I don't get what I'm doing wrong here.
Can all five controls be in the Detail section? What could be some
problems? Anyway, how should I do this.

IF your form is tall enough to display the longest memo
field, then you can use the fTextWidthHeight function at
www.lebans.com to calculate how tall to make the memo
field's text box. Then use that to set the other two text
box's Top property.

If the form is not tall enough, then you have a design
dilemma to resolve.

Personally, I recommend just making the memo text box 3 or 4
lines tall and if it exceeds that, let users scroll it.