Query not returning all characters

  • Thread starter Thread starter Vic
  • Start date Start date
V

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
 
-----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
.
Click to expand...
A Text field is limited to 255 characters.
 
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
Click to expand...
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
 
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
Click to expand...

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.
 
Back
Top