Field value got truncated, why?

[vman21]

Greetings.

I have encountered an issue when I was inserting a string (with newlines about 176 characters) into access table. This field in access has the data type TEXT and it was truncated after the insertion. It is strange because I have three other fields with the same format and no truncation at all. May I know what could be the reason and how/what is the recommened data type for storing long text?

 

[Frothingslosh]

Text fields default to a max length of 50. Have you changed this value in the table's design view?

 

[vman21]

Text fields default to a max length of 50. Have you changed this value in the table's design view?

Thanks you are right. Would it be better if I change the data type to memo as it can hold 64k characters? I understand that it cannot store formatting.

 

[David R]

Text fields in Access 2010 and later can go up to 255 characters, if you change the field size. Would that suffice? It's not clear if 176 is average, standard, or high.