Truncated memo fields on reports

[RedSkies]

Hi all,

I'm having a problem with memo fields on reports truncating after the first 255 characters. The full content of the fields displays perfectly on the form but not on the report. Here's the other weird item: the entire field contents display in the results of a "base" query but not in the actual report record source query. (i.e. The report is based on Query A which is based on another Query B. The data appears in full in the results of Query B but when I run Query A, it's truncated.)

I've already looked through all the other posts on similar topics previously posted on this forum and ruled out the causes documented in the MS Knowledge base.

Has anyone else had a problem like this and come up with a workaround? The report isn't going to be much good with big chunks of data missing from it!

Thanks in advance for your help.

 

[Rich]

Can you use DLookup?

 

[RedSkies]

Rich,

Sorry, use DLookup how? Not really sure what you mean.

Thanks!

 

[Rich]

Is it a totals query?

 

[RedSkies]

Yes, the query on which the report is based (I called it Query A above) uses an aggregate function (Max). Is that the problem?

 

[UniqueTII]

I'm having a similar problem going from queries to tables. It seems to lack a solution.

 

[Rich]

What do you mean, going from queries to tables?