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.

 

[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