Display Memo field text in Access Form

[reggiete]

Hello,

I have a memo field in a table that has 500 characters. I want to display the text in a field on a form, but text fields are limited to 160 characters. How can i get the full string of text from the memo field in the access table to display on a form field?

 

[Minty]

A text box is not limited in size to display (if it is I think it is 65546 characters). Where are you seeing this limitation?

If you are performing any data manipulation in the underlying data for the form you could be seeing memo field truncation. http://allenbrowne.com/ser-63.html

 

[reggiete]

Well when i link a text field to the memo field on the table and view the form its cut the txt off. But when i look in the table i can see the full string of text.

 

[Minty]

I don't understand what you mean when you say link a text field to a memo field.
A text field is limited to 255 characters.

 

[reggiete]

Sorry, When you create a textbox on a form and you set the recordsource as the name of the field in the table which is set as a memo field on the table.

So when a view the form in FORM view i see part of the text string which is cut off at 255 characters.

 

[Minty]

I haven't ever seen that unless you are setting some format on the textbox or as per the link I posted earlier you are doing any sort of aggregate functions.

Can you post up a sample db to demonstrate?

 

[reggiete]

Please see attached. The box black box is the field on the form and i also ss the properties for the field box

 

[kevlray]

I am kinda curious what that symbol is in the Format property of the text box (resolution of the picture is not good enough)? FYI: I just created a test DB (2010) and created one table and one memo field. Dropped into a form and put some very long text in (~3000 characters). It appears to display just fine.

 

[reggiete]

awesome... I removed the @ on the form field and table and now the full string of text displays