Quick question - Report - Memo Field

  • Thread starter Thread starter luis.a.roman
  • Start date Start date
L

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
 
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
Click to expand...

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.
 
Back
Top