Query field size quandry

[James]

I have a memo data field in a table that when pulled by a particular query,
cuts off the data at 255 characters.
Originally it was a Text field in the table(255).
The table memo field contains maybe 350 characters.
When a new query is created to test, all 350 characters are extracted to the
query field.

I have deleted the table's field from the original query, saved it, repaired
the DB, and re added the field to the query.
I have renamed the table data field and added it to same query, with the
same problem.

This is crazy, what am I overlooking?
What about a query field is limiting the field size?

Any suggestion appreciated.

 

[James]

I have a memo data field in a table that when pulled by a particular query,
cuts off the data at 255 characters.
Originally it was a Text field in the table(255).
The table memo field contains maybe 350 characters.
When a new query is created to test, all 350 characters are extracted to
the query field.

I have deleted the table's field from the original query, saved it,
repaired the DB, and re added the field to the query.
I have renamed the table data field and added it to same query, with the
same problem.

This is crazy, what am I overlooking?
What about a query field is limiting the field size?

Any suggestion appreciated.

Resolved!!

I removed the Totals field of the query.

 

[John W. Vinson]

Resolved!!

I removed the Totals field of the query.

You can actually include a memo field in a Totals query without truncation -
you just must not Group By it. Use another operator such as First.
--

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