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,

On Wed, 17 Nov 2010 07:57:34 -0800 (PST), inungh <(E-Mail Removed)> wrote:

>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/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com

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 W. Vinson wrote:
> On Wed, 17 Nov 2010 07:57:34 -0800 (PST), inungh <(E-Mail Removed)> wrote:
>
> >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/For...-US/accessdev/
> http://social.answers.microsoft.com/.../en-US/addbuz/
> and see also http://www.utteraccess.com

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

On 11/17/2010 10:57 AM, inungh wrote:
> 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,
>