By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,250 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

memo field auto-expanding?

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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/
Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.