I have a table to contains 2 memo fields (besides a bunch of text and number fields).
In one of the record's memo field, the "character count" is 555 characters (with spaces).
Now, once I created a query and inserted the 2 memo fields. In the query, I lose some characters lots of text.
For instance the record that has 555 characters now shows only 255 characters in the query.
I am vaguely familiar about about the 256 max character concept. However, that's why I chose "Memo" as data type for this field. I was under the impression I would have an unlimited amount of characters to enter.
Again, it's only the query that drops characters (not the table). Why is that? And how can I fix it in the