CODEWITHSUNDEEP
ms-accessms-access-2016
Ice s. Woo
Ice s. Woo

Reputation: 27

Only the first 255 characters of the long text field was kept when create a query using a table in Access 2016

I have a field with a long paragraph (long text type) in a table, once I conduct a query on it, the paragraph then being cut off in query's datasheet view (Only the first 255 characters was kept). Anybody know what caused the problem and how to solve it?

Upvotes: 0

Views: 752

Answers (1)

Minty
Minty

Reputation: 1626

This is a common problem with Memo or Long text (As they are now called) fields once they are queried in certain ways.

There is a full explanation here http://allenbrowne.com/ser-63.html

It is caused by limitations with Access, but the link shows a number of workarounds.

Upvotes: 4

Related Questions