Text truncated in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two separate forms based on two distinct select queries. Both draw
from the same table. Query 1 draws straight from the table with no joins.
Query 2 has a join to another table. Memo field text in the query with the
join is truncated at 255 characters whereas text in the query with no join is
fine. There is no sorting, calculating or anything in either query.

Can anyone advise me on this?
 
Eric G said:
I have two separate forms based on two distinct select queries. Both draw
from the same table. Query 1 draws straight from the table with no joins.
Query 2 has a join to another table. Memo field text in the query with the
join is truncated at 255 characters whereas text in the query with no join is
fine. There is no sorting, calculating or anything in either query.
Click to expand...


That will also happen if you use the query keyword DISTINCT,
GROUP BY or a few other things.

Another cause is using a Format setting for the memo's text
box in the report.
 
This is extremely interesting! I viewed the query's SQL, took out the
'DISTINCT' keyword, ran the query and it eliminated the problem. I am
wondering 1) if this behavior is by design and if so what purpose it serves
and, 2) what does does the 'DISTINCT' keyword do?

Thanks.

Eric
 
The purpose of the DISTINCT keyword is to eliminate
duplicate records in the query's result set. It should only
be used when you have a specific need for its functionality.

This requires that Access compare every field in every
record to see if they are the same. It's the comparison of
memo fields that causes the truncation. That's why using a
memo in the ORDER BY or GROUP BY clauses also causes
truncation.
 
Back
Top