can I create a field that grows as I type in an Access Form

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

Guest

I would like to create a memo field that grows as I type on a Form in Access
2003. Some other answers talk about this but I'm simply not getting it.

Thanks
 
I would like to create a memo field that grows as I type on a Form in Access
2003. Some other answers talk about this but I'm simply not getting it.

Thanks
Click to expand...

Access Form control's do not get bigger as you type.
You use scroll bars within the control to view all the text.

When you print the text in a report, you can set the Report Control
and the Section of the report the control is in property to CanGrow,
which will then display all of the text.
 
I'd really like the box to grow, if possible. So, is it possible to make a
text field that grows as you type in an Access Form?

Thanks and have a great day.
 
Anything can be done. I guess you could change the height property of the box
depending on how much text is in it. You would have to calculate the number
of lines in the box based on the total number of characters in the text
divided by the average or approximate number of characters available on each
line, then resize each time there is enough additional text to warrant a
resize.

Not much fun, though.

As noted, the CanGrow property of a control is effective only when the form
is printed or previewed, not at edit/input time.
 
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.



History

Version 4.5: Increased accuracy of auto sizing for a ListBox.

Version 4.3: Added sample Form to demonstrate auto sizing for a ListBox.
--

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