Memo Field is truncating to 255 Chars

[Jim Pockmire]

The source query is using "totals" and the condition for the memo field is
set to "First". This displays the entire contents of the memo field (more
than 255 chars), vs using "Group By" which truncates the field to 255 chars.

However, even though the entire string displays in the query - only the
first 255 print on a report. Is this normal?

Is there a way to print the entire string, other than a sub-report?

 

[Allen Browne]

It seems you understand that to get Access to display the entire memo field,
you must avoid any aggregation on the field.

It sounds like you succeeded in doing that in your query, so (assuming this
query is the source for the report), it's time to look at the report. Open
it in design view. Open the Sorting And Grouping dialog (View menu.)
Anything in there that would cause Access to sort or group on the memo
field? Is the memo in the Detail section, or in some group header/footer? Is
there anything in the report's OrderBy property?

Another place to look is the Format property of the text box that shows the
memo. Clear anything from that property.

 

[Jim Pockmire]

The answer to your questions is generally "no". I even created a test report
using simple dummy data and a simple report which retrieves one record with
no grouping.

The report truncates the data wheras the query does not, so I am assuming
this is normal.

My work around is a sub-report, although the above would have been easier if
it worked.

 

[Allen Browne]

Okay, so you have a subreport that works, but a main report that doesn't.
That may help you to identify what's the difference between the two.

 

[Jim Pockmire]

Yes, the sub-report is based on single table with no grouping - so the memo
field does not become an issue

 

[Rick Brandt]

Yes, the sub-report is based on single table with no grouping - so
the memo field does not become an issue

Are you using the memo field in the report to do the grouping?

(you can't do that)

 

[Marshall Barton]

The answer to your questions is generally "no". I even created a test report
using simple dummy data and a simple report which retrieves one record with
no grouping.

The report truncates the data wheras the query does not, so I am assuming
this is normal.

My work around is a sub-report, although the above would have been easier if
it worked.

To add to Allen's list of things to check. Did you make
sure the memo's text box and its section bothe have their
CanGrow property set to Yes?

IMO, once the query is doing the right thing, this problem
is usually caused by some kind of grouping, aggregation or
sortingon the memo field.