By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,961 Members | 2,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,961 IT Pros & Developers. It's quick & easy.

Memo field truncated in query/report?

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.