Shrink and grow a Memo field in a form?

[Abi]

How do I set the properties of a memo field on a form so
that it will expand or contract based on the number of
characters entered?

We are trying to limit how much space a field will take
up on the screen, so if the memo box would adjust to the
amout of data inside, it might save some space.

Thanks!

 

[Claire]

You won't be able to make the memo field shrink and grow
on the form on screen, that can only happen when a form or
report is being printed.

If data is entered into the memo field on screen, the memo
field will obtain a scroll bar as the data gets too deep
for the alotted space.

If you want to be sure that the memo field will grow as
needed when printing the form or report, set the Can Grow
property to Yes. It can only grow vertically.

HTH

 

[Stephen Lebans]

If the form is not in Continuous or Datasheet view then 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.