Quick question - Report - Memo Field

[luis.a.roman]

I have two fields in a report that are "Memo" type. I defined this
fields in a report as they can Grow and/or Shrink. However, the
information on this fields is trucated.

Any suggestions on how to correct this problem.

Thank you for you collaboration and guidance.

Luis

 

[Rick Brandt]

I have two fields in a report that are "Memo" type. I defined this
fields in a report as they can Grow and/or Shrink. However, the
information on this fields is trucated.

Any suggestions on how to correct this problem.

Thank you for you collaboration and guidance.

Luis

There are several things that will truncate a memo field to 255 characters.

In a query:
Using a UNION query without UNION ALL
Using DISTINCT (unique values)
Using Group By on the Memo Field
Applying a format property to the memo field column

In a Report
Using the Memo field in the Grouping tool
Applying a format property to the TextBox of the Memo field

There might be a few others.

 

[missinglinq via AccessMonster.com]

Here's a link to an excellent paper by the illustrious Allen Browne on the
subject. He includes workarounds.

http://allenbrowne.com/ser-63.html