Memo field truncating in report

[sylvanst]

Hello,

I have built an Access Query that includes a memo field. When I try to display the results of that query memo field in either an Access report or Crystal report the data truncates and doesn't display the full data result.

The data in the memo field can get quite large and I want all the data displayed.

Is there some bug going on with queries and memo fields or do I need to adjust some setting?

Thanks,

Kent

 

[Rick39]

Set the memo field Can Grow to yes.......if that doesn't do it, See

http://support.microsoft.com/default.aspx?scid=kb;EN-US;281153

 

[annsolomon]

Set the Can Grow property of the memo field on the report to Yes. Ann

 

[annsolomon]

Oops! Looks like we bumped into each other. Sorry. Ann