Displaying memo on report

[Brian Martin]

i ahve a form based on the following query:

SELECT DISTINCTROW tblassys.Specs, Join.*
FROM [Join], tblassys
WHERE (((tblassys.ListID)=Join.ListID)) And (((Join.ListID)=Forms!CurrentList!ListID));

Specs is a memo.
The text box for displaying Specs on the report has can grow and shrink set to True.

When I run the query on its own all the text in the memo is displayed in the result.

But the report only shows 255 characters of specs.

I have read many other threads from people who have had similar problems and nobody seems to have come up with a good answer to this problem. Is there anyone out there who can shed some light on this mystery??

 

[llkhoutx]

You're chopping off your memo field somewhere. If the data ever gets into it, it will print.