Query field size quandry

  • Thread starter Thread starter James
  • Start date Start date
J

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 said:
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.
Click to expand...


Resolved!!

I removed the Totals field of the query.
 
Back
Top