Need help with displaying text in memo box on a form

[cdell7up]

I have an form that I would like all the text to display in a memo field. Some of the text in the memo field my be several sentences long, and right now it will not display all of the text in some fields. I would like for the text to wrap and expand the memo box. Can anyone help me on this.

[tanvi]

It is only happens when the memo field is grouped, the data is truncated at 255 characters. To work around the problem, choose first instead of group. This will retain the memo field length and display all data. Check this article for more information about the issue: http://allenbrowne.com/bug-18.html

[June7]

Textbox on form will not grow. Make the box tall enough (at least two lines high) and the vertical scroll bar will be available.

[Missinglinq]

tanvi, you should note that the OP is talking about a Memo Field being displayed on a Form, while Allen's article is talking about the problem on a Report.

cdell7up, in addition to June7's sound advice, if you require more 'room' than you have 'real-estate' on your Form to display, you could use the Double-Click event of the Memo's Textbox to either run the Zoom Command to expand the Control, temporarily, or a custom 'zoom box,' which uses a second, larger Textbox for the Field and controls its Visibility, as needed.

Linq ;0)>

[cdell7up]

Textbox on form will not grow. Make the box tall enough (at least two lines high) and the vertical scroll bar will be available.

I forgot to mention the form is actually a subform. Is there a way to do this in a subform?

[June7]

Is it in DatasheetView? The scroll bar will not show. In Form view can resize the entire record height to show all data. But this might not be practical for a memo field with very long string.

Missinglinq's ideas might work regardless of view. I never tried.

[cdell7up]

tanvi, you should note that the OP is talking about a Memo Field being displayed on a Form, while Allen's article is talking about the problem on a Report.

cdell7up, in addition to June7's sound advice, if you require more 'room' than you have 'real-estate' on your Form to display, you could use the Double-Click event of the Memo's Textbox to either run the Zoom Command to expand the Control, temporarily, or a custom 'zoom box,' which uses a second, larger Textbox for the Field and controls its Visibility, as needed.

Linq ;0)>

I like this idea. My questions are I know how to get to the double click event in the properties menu. How do I get the command Zoom as a control. Do I need to create a macro?

[June7]

Google: microsoft access zoom box

See if this helps http://www.tutorialized.com/tutorial...ess-2007/41247