473,225 Members | 1,255 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,225 software developers and data experts.

memo field auto-expanding?

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
2 5703
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Shyguy | last post by:
I want to create two buttons on a form. One would allow the user to Copy the contents of the current records memo field, the other would allow them to print. I set up a report based on the memo...
3
by: GorDon | last post by:
Hi, I have a report based on a query. The query grabs a memo field from my main table, yet when I display the memo field in the report it truncates the memo field (the field needs to hold more...
3
by: John | last post by:
I have a field, data type Memo, in a job details table. I have a text box on a report which I need to print the contents of this field. My problem is that the text box will only display 255...
4
by: Mark Reed | last post by:
Hi All, here is what I am trying to achieve. I have a memo field on a form which users will need to add to as and when. I do not want them to be able to edit information which already exists...
1
by: alexsg | last post by:
A little while ago Ron P kindly responded to my inquiry on how to copy the first line of memo field into a text field, using a query: left(,instr(1,,vbCrLf)-1) This is great, but I would like...
7
by: midlothian | last post by:
Does using CStr on a memo field truncate it to 255 characters? Seems like this is happening with some data in my tables. Is there a way around this?
9
by: RMC | last post by:
Hello, I'm looking for a way to parse/format a memo field within a report. The Access 2000 database (application) has an equipment table that holds a memo field. Within the report, the memo...
2
by: Teresa L | last post by:
I am using Access 2003. I have a memo field that I have put into a report. My problem is that the report will only show a specific amount of characters in the report. It does not display the...
2
by: Roger | last post by:
I've got two tables in sql2005 which have an 'ntext' field when I linked the first table in access97 last week using an odbc data source the access-field type was 'memo' when I link the 2nd...
11
tdw
by: tdw | last post by:
Hi all, I have tried a few different methods to accomplish this, but with no luck. I will post the code for the latest attempt at the end of this post. I work at a land surveying company. This...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.