Memo Field vs. Text Field (Limitation)

[Tom Bock]

I use a memo field in a table. Some data in the memo field are
approximately 500 characters.

Now, in a linked report, only up to 255 characters are being displayed in
the report. I know there is some limit to textboxes (that's why I chose
the memo to begin with).

Is there a way to have a memo field on the report or change some properties
so that all data of the memo field can be displayed in the report?

Thanks,
Tom

 

[Rick Brandt]

I use a memo field in a table. Some data in the memo field are
approximately 500 characters.

Now, in a linked report, only up to 255 characters are being displayed in
the report. I know there is some limit to textboxes (that's why I chose
the memo to begin with).

Is there a way to have a memo field on the report or change some properties
so that all data of the memo field can be displayed in the report?

If your report control or your query field applies a format property to the
memo field it will be truncated to 255 characters. Also if your query is
using DISTINCT or GROUP BY on the memo field.

 

[Tom Bock]

Thanks, that works!

Tom

If your report control or your query field applies a format property to the
memo field it will be truncated to 255 characters. Also if your query is
using DISTINCT or GROUP BY on the memo field.