469,890 Members | 1,414 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,890 developers. It's quick & easy.

Memo field truncated in query/report?

Hi,
I have a report based on a query. The query grabs a memo field from
my main table, yet when I display the memo field in the report it
truncates the memo field (the field needs to hold more than 255
characters). The table holds all the memo text, but the query seems
to truncate the memo field to 255 chars?

This seems like there should be a relatively easy fix, but I can't
seem to find it.

Any ideas/help would be most appreciated.

Thanks,
Gordon
Nov 12 '05 #1
3 9916
Make sure you don't have any formatting on the memo field in the query
or the report. Any type of formattin on a memo field seems to truncate
it.

GorDon wrote:

Hi,
I have a report based on a query. The query grabs a memo field from
my main table, yet when I display the memo field in the report it
truncates the memo field (the field needs to hold more than 255
characters). The table holds all the memo text, but the query seems
to truncate the memo field to 255 chars?

This seems like there should be a relatively easy fix, but I can't
seem to find it.

Any ideas/help would be most appreciated.

Thanks,
Gordon

Nov 12 '05 #2
Norman Scheinin <no***************@boeing.com> wrote in message news:<3F***************@boeing.com>...
Make sure you don't have any formatting on the memo field in the query
or the report. Any type of formattin on a memo field seems to truncate
it.
Checked... No I don't have any formatting on the memo field, in the
query or the report?

GorDon wrote:

Hi,
I have a report based on a query. The query grabs a memo field from
my main table, yet when I display the memo field in the report it
truncates the memo field (the field needs to hold more than 255
characters). The table holds all the memo text, but the query seems
to truncate the memo field to 255 chars?

This seems like there should be a relatively easy fix, but I can't
seem to find it.

Any ideas/help would be most appreciated.

Thanks,
Gordon

Nov 12 '05 #3
Have you set the "Can Grow" feature of your text box in the report to
"Yes". If you don't the amount of text displayed is limited.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by jacoballen | last post: by
2 posts views Thread by Teresa L | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.