My control on a form has memo as it's data type, how do I get the.

[Guest]

I have a subform in a form that has a control on it allowing me to enter data
that is on more than one line, I want the control to increase in height
depending on how much data is entered, ie if 2 lines of text are entered I
want the height of the row to increase so you can see it all. is this
possible to do?

 

[Dirk Goldgar]

I have a subform in a form that has a control on it allowing me to
enter data that is on more than one line, I want the control to
increase in height depending on how much data is entered, ie if 2
lines of text are entered I want the height of the row to increase so
you can see it all. is this possible to do?

If the subform is in single form view, then this from Stephen Lebans is
what you're looking for:

http://www.lebans.com/textwidth-height.htm
TextHeightWidth.zip is a replacement for the Report object's
TextWidth and TextHeight methods. It is multiline aware and
can work in both Report and Form views. Includes a sample
report to show you how to autosize individual controls with
different formatting on the same line to simulate RTF style text.

You spoke of increasing the "height of the row", though, which leads me
to believe you're in continuous forms or datasheet view. If that's the
case, I don't believe you're going to be able to get different rows to
have different heights, though I expect you can easily get all rows to
match the height required for the current row.