Displaying long message on form

[Ken Warthen]

I have an Access 2007 form on which I'm trying to display the body or message
of an email that is selected from a listbox showing email dates and subjects.
The data is coming from a table called tblEmailLog. Since a textbox is
limited to 255 characters and the actual message (which is stored in a memo
field) may be longer than that, what is the best way to display the message.
I tried using a listbox, but there's no word wrap available, so that's not a
solution either.

TIA,

Ken

 

[Dennis]

Use a Memo field on your form instead of a TextBox

 

[Dennis]

Forget my last post. If the table that holds the message body of the e-mail
is a memo field, then a textbox on your form will hold and display it.

 

[J_Goddard via AccessMonster.com]

Hi -

A text box on a form is not limited to 255 characters (unlike a field of type
Text in a table) - it can display any amount of text. How else could you
display or enter memo field data? Using the memo field as the control source
for the text box will be fine, though you will need the scroll bars to see
all the data.

John

 

[Ken Warthen]

I'm getting the memo field data for the email message from a column in a
combo box (strEmailMessage = Me.lstEmailLog.Column(2, intRowSelected)) and
displaying it using Me.txtEmailText.Value = strEmailMessage
Is there any reason why this code would be truncating the message value when
it exceeds 255 characters?

Ken

 

[Ken Warthen]

I'm getting the value for the email message from a column in a combo box (
strEmailMessage = Me.lstEmailLog.Column(2, intRowSelected)) and then
displaying it in the textbox using Me.txtEmailText.Value = strEmailMessage
Is there any reason why the above code would be truncating the value of
messages that exceed 255 characters?

Ken