255 Character Limit on Query Fields

[HairyArse]

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]

make the long text field as the first select field in your query, ie:

SELECT memoField, field1, field2, ....

 

[CJ_London]

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

 

[Minty]

As others have suggested it will be to do with your query.
Read here about Memo field (Long text in later access versions) truncation and some work arounds.
http://allenbrowne.com/ser-63.html