Memo 255 character limit - not printing on report

[susanmgarrett]

I've checked the archives for answers to this question, but none of them seem to apply.

I have a query as follows:

SELECT weblist.[CD Action], weblist.[Digital Action], weblist.[CD Num - Original], weblist.[CD Title - Original], weblist.[Print List Text]
FROM weblist
ORDER BY weblist.[CD Action], weblist.[AKCD-Original];

One of the field [Print List Text] is a memo field.

When I link the query to a report, the memo field will only print 255 characters.

Is there a way for me to unlock that limitation on the report.

Thanks.

S. Garrett

 

[Smart]

Set the can grow option of The field on the report that is to hold the memo information to Yes
(properties,format,cangrow)

 

[susanmgarrett]

Can Grow has no effect

I've set the field on the report to Can Grow with absolutely no effect. It still cuts off at 255.

Thanks for the suggestion, though.

 

[Rich]

Take the order by out of the query to start with

 

[susanmgarrett]

Removing Order By worked!

Thank you very much. The removal of Order BY now means the field will print more than 255 characters.

Thank you very much for the assist.

 

[Fear Naught]

Take the order by out of the query to start with

Even thought it appears to have worked for the original postee can anybody explain why ??

 

[RuralGuy]

Maybe this link will help. http://www.accessforums.net/ftopic5593.html