Auto Expand Text/Memo box?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

good day all,

Is there a a way to set up a memo or text box so that the box will
"expand" and "retract" to the amount of data that is in the box?'

Hope this is clear..

Thanks,

Brook
 
See:
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.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Hello Stephen,

Thanks so much, this is exactly what I was looking for!

Just one question. The initial code to set the text box size? - The text box
I'm working with is on a subform, so should I add it to the oncurrent of the
subform or mainform?

Thanks,

Brook
 
Back
Top