Truncated memo field display

[Marv]

Hi,

I have a very basic report displaying Last Name, First Name, Class, and a
Memo. Sorted by Class then Last name.

The report displays properly until I click on Sigma to set up the ability to
display the count of each Class. Without making any other change except
clicking on Sigma every memo field displayed in the report is truncated to
about 300 characters and spaces.

Thanks for any suggestions.

Marv

 

[Tom van Stiphout]

On Mon, 5 Oct 2009 09:58:34 -0400, "Marv" <[email protected]>
wrote:

I'm assuming you clicked on Sigma when designing the query for the
report.
It truncates at 255 chars, and that is by design. This is a
performance optimization, because grouping by a potentially very large
memo field can be too time consuming.

Fortunately, you don't need to Group By at all: leave the query the
way it was, and in your report create a grouping level for Class. Then
in that grouping level's footer create a textbox and set its
controlsource to:
=Count(Class)

-Tom.
Microsoft Access MVP

 

[George]

That is a known Issue with memo fields in aggregate queries. Allen Brown,
http://allenbrowne.com/ser-63.html has a summary and some suggestions on
handling it.

George

 

[Marv]

Tom and George,

Thanks for the info.

Marv

That is a known Issue with memo fields in aggregate queries. Allen Brown,
http://allenbrowne.com/ser-63.html has a summary and some suggestions on
handling it.

George