<div>
Not really sure I understand..., so try the above experts suggestions first...<br />
<br />
For me, it would be clearer if you posted an image of the results you get now.<br />
Then post a clear graphical image of exactly what you do need.<br />
<br />
But posting a simple sample db that exhibits this issue would be better...<br />
<br />
JeffCoachman
</div>


Not really sure I understand..., so try the above experts suggestions first...

For me, it would be clearer if you posted an image of the results you get now.
Then post a clear graphical image of exactly what you do need.

But posting a simple sample db that exhibits this issue would be better...

JeffCoachman

<div>
You can use a look-up function:<br />
<br />
<a href="https://www.experts-exchange.com/questions/28554757/Access-Query-truncates-Memo-Field.html?anchorAnswerId=40434530#a40434530" rel="ugc">https://www.experts-exchange.com/questions/28554757/Access-Query-truncates-Memo-Field.html?anchorAnswerId=40434530#a40434530</a><br />
<br />
/gustav
</div>


You can use a look-up function:

https://www.experts-exchange.com/questions/28554757/Access-Query-truncates-Memo-Field.html?anchorAnswerId=40434530#a40434530 [https://www.experts-exchange.com/questions/28554757/Access-Query-truncates-Memo-Field.html?anchorAnswerId=40434530#a40434530]

/gustav

<div>
<div class="content wysiwyg-content">
How do I change a field in a report so it includes more text? It is a memo field that has up to a paragraph of info. Currently it is cutting if off randomly. I don't need the entire memo, but I would like more that is showing. I don't need it to grow either (with a long one) I'd like to have a maximum size it will reach.<br />
<br />
Thanks!
</div>
</div>


How do I change a field in a report so it includes more text? It is a memo field that has up to a paragraph of info. Currently it is cutting if off randomly. I don't need the entire memo, but I would like more that is showing. I don't need it to grow either (with a long one) I'd like to have a maximum size it will reach.

Thanks!

Memo field in a report

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.