Query not returning all characters

[Vic]

I have a query that is truncating characters from a field
when i executed. It appears that it is only allowing 255
characters on the result. The table shows all the
characters, but the query is truncating them. How can I
increase the number of character the query returns?

TIA,
Vic

 

[Roxie Aho]

-----Original Message-----
I have a query that is truncating characters from a field
when i executed. It appears that it is only allowing 255
characters on the result. The table shows all the
characters, but the query is truncating them. How can I
increase the number of character the query returns?

TIA,
Vic
.

A Text field is limited to 255 characters.

 

[John Nurick]

Hi Vic,

This can happen if the the field in the query is formatted (e.g. with a

or < ) or in some circumstances if it's a calculated field using

functions such as Left() or Mid(). In the latter case, installing the
latest Jet service pack is meant to fix it. See the links below.

If the data is being truncated on exporting to Excel or a text file,
things are a bit more complicated. Post back if that's the case.

http://support.microsoft.com/default.aspx?kbid=259893
http://support.microsoft.com/default.aspx?kbid=239114

 

[John Vinson]

I have a query that is truncating characters from a field
when i executed. It appears that it is only allowing 255
characters on the result. The table shows all the
characters, but the query is truncating them. How can I
increase the number of character the query returns?

TIA,
Vic

Care to post the SQL?

If you're sorting or grouping by the field, be aware that Memo fields
*will* be truncated. Solution: don't sort, group, or format Memo
fields.