Truncated to 255 problem

[DblDogDare]

I have a query that is giving me a problem truncating a memo (table) field. Here is the scenario and some tests I have performed. The table field in question is a memo field. This table has a many to one relationship to another table on a different field. I have created a query using these 2 tables. The memo field is truncating to 255 characters.
I have tested several options and here are the results. I used the 1 table in the query with the memo field only. I have the entire memo in the query field as a single recordset. I add the second table and still have the entire memo in the single field, however due to the many, I have multiple instances of this recordset. This is where the problem occurs. If I set the query property to "Unique values" and run the query, it limits the field to 255 characters. Any ideas on how to fix this???

 

[Newman]

I'm not sure, but I'll give it a try...
What if you use your query without the memo field, then use another query with the previous query and the table with the memo field. Bring every fields from the query and the memo field from the table?