Need to see more than 255 characters in a text box...

[ToyFox]

I am linked to an Outlook mailbox. I have a form with a textbox that gets its value from the linked mailbox "body" field. Textbox can only hold 255 characters...what can I do to display the contents of the memo field.

 

[dhookom]

A text box can display thousands of characters.

Duane
Hook'D on Access
MS Access MVP

 

[ToyFox]

Its cutting off at 255...

 

[dhookom]

Where is it cutting off at 255? Did you check the table or query? If the record source of the form is a query, what is the SQL view?

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

Not sure how you have this set up. Is it a linked table or are the contents imported into a table. If you link the table the field is called "Contents" and it is a memo field. If you import into a table, ensure that the contents field is memo.

 

[ToyFox]

Its the linked field that is a Memo field. But I dont see more than 255 in the text box. What am I doing wrong?

 

[MajP]

If you look at the linked table in design view is the "Content" field memo. I do not know how it could not be because this cannot be altered. But if it is not a memo field I have an idea.

 

[dhookom]

But I dont see more than 255 in the text box

Forget the text box. Why not answer my questions

Did you check the table or query? If the record source of the form is a query, what is the SQL view?

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

Good point Duane.

My guess is that the linked table is correctly bringing in the memo field, but you are using the linked table in a query as Duane points out. If that is the case, there are several possibilities for truncation.

http://allenbrowne.com/ser-63.html

Also as Duane points out the truncation has nothing to do with the form's text box but only the source data.

 

[dhookom]

Thanks MajP. You have expressed my concerns much better than I ;-)

Duane
Hook'D on Access
MS Access MVP