memo field auto-expanding?

[Kevin]

Thanks for the very quick response posting that I can use a memo
datatype to store large amounts of text.

I understand that I can turn on "Can Grow" for a memo type, but is
there either a property or VB code that will allow the text box to
expand vertically as the user adds lines, so that it isn't necessary to
use the vertical scroll bar to view text above/below the displayed
window? I'm looking for a sort of dynamic autosize.

[Steve Jorgensen]

On Tue, 26 Jul 2005 05:23:35 GMT, "Kevin" <ke****@sonic.net> wrote:

Thanks for the very quick response posting that I can use a memo
datatype to store large amounts of text.

I understand that I can turn on "Can Grow" for a memo type, but is
there either a property or VB code that will allow the text box to
expand vertically as the user adds lines, so that it isn't necessary to
use the vertical scroll bar to view text above/below the displayed
window? I'm looking for a sort of dynamic autosize.

It would be hypothetically possible to write code for that, but defintely
non-trivial. The hardest parts of the work could be done by reusing code
Stephen Lebans has on his Web site - http://www.lebans.com/

[Salad]

Kevin wrote:

Thanks for the very quick response posting that I can use a memo
datatype to store large amounts of text.

I understand that I can turn on "Can Grow" for a memo type, but is
there either a property or VB code that will allow the text box to
expand vertically as the user adds lines, so that it isn't necessary to
use the vertical scroll bar to view text above/below the displayed
window? I'm looking for a sort of dynamic autosize.

I suppose you are lacking some real estate on the screen to make a large
memo field.

If you click Shift-F2 on a table or query's field, a zoom box will open
up but it doesn't have a maximize button. I suppose you could effect a
similar thing and create a form that is big and maximized that is
nothing but a huge memo field with maybe a command button to save or
cancel. Have some hot key open up the large memo form and pass via
OpenArgs the form/field, stuff the memo field from the current memo.
When closed, update data in the calling form/field if saved.