255 Character Limit on Query Fields (1 Viewer)

HairyArse

Registered User.
Local time
Today, 20:53
Joined
Mar 31, 2005
Messages
92
Hello guys.

I am having a problem with a query in that it truncates longtext fields to 255 characters. Having read up on this, it seems this is a restriction enforced by Access, for whatever reason.

Does anyone know of a way around this?

I have to use a query as opposed to a report as the data gets pasted into a custom Excel spreadsheet.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:53
Joined
May 7, 2009
Messages
19,169
make the long text field as the first select field in your query, ie:

SELECT memoField, field1, field2, ....
 

CJ_London

Super Moderator
Staff member
Local time
Today, 20:53
Joined
Feb 19, 2013
Messages
16,553
depends on the query - group by/crosstab, union will all truncate to eliminate/identify duplicates.

Other things (again to do with duplicates) is using distinct or distinctrow with select
 

Users who are viewing this thread

Top Bottom