disctinct query memo field

[inungh]

I have a select disctinct query with memo field returned.
I know that for some circumstance that the query return only first 255
characters of the field.

I have one applicaiton running in 2 places. One place returns all memo
field, but the other only returns first 255 characters.

I beleive that for the one applicaiton does not work that I am missing
something there.


Your information is great appreciated,

 

[John W. Vinson]

I have a select disctinct query with memo field returned.
I know that for some circumstance that the query return only first 255
characters of the field.

I have one applicaiton running in 2 places. One place returns all memo
field, but the other only returns first 255 characters.

I beleive that for the one applicaiton does not work that I am missing
something there.


Your information is great appreciated,

Be sure that you don't have a Format property specified on the memo field;
that you're not sorting or grouping by it; that it's not a field in a UNION
query (UNION ALL will work, UNION won't).
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[inungh]

Thanks for helping,
There is no format in the memo field and it is not an union query.
there is no sorting or grouping.

It is an identical application, but work on one place, but the other
one.
It seems that the MS Access option setting, but I check all the option
settings are identical as well.

Thanks again,

 

[John Spencer]

As far as I know, the use of the DISTINCT keyword in the query will ALWAYS
truncate the memo field to 255 characters.

If the memo field is not being truncated, I would check the query and make
sure the query was using distinct and the query that you are looking at is the
query that is actually executing.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County