Memo Field vs. Text Field (Limitation)

  • Thread starter Thread starter Tom Bock
  • Start date Start date
T

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
 
Tom Bock said:
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?
Click to expand...

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.
 
Thanks, that works!

Tom


Rick Brandt said:
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.
Click to expand...
 
Back
Top