Printing Memo Fields without Truncation

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Give it a try. You can unsubscribe at any time.

How to print larger Memo fields without truncation.

Q: Tara Santmire wants to know how to print Memo fields with more than 255 characters on an Access report, without truncation.

A: All you need to do is set the CanGrow property of the text box bound to the Memo field to Yes.

Make sure that there are no other controls on the same line (that can interfere with the CanGrow property), and the text box will expand as needed to display all the Memo text.

Want More?

Office Watch has the latest news and tips about Microsoft Office.  Delivered once a week.