Hi Everyone.

I have a report which is pulling data from a query. The memo field is complete in the query but when displayed in the report it is truncated. Anyone know how or why this is happening?

Thanks

Mike

Mike
EchoVue.com

__________________
Mike
EchoVue.com

are you sorting on the memo field?

If yes, this will cause the truncation to 255 characters.

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com

Hi Boyd,

Not from what I can see... I also checked to ensure I wasn;t grouping on it and that seems clear as well.

I have created another report with the same query and it works just fine in there, so my next step is to copy the nice formatting over the new report and see if that makes a difference.

Access usually plays nice with my, but has been a little sneaky the last few days!!

Thanks again,

Mike

Mike
EchoVue.com

Hi Boyd,

This is report is interesting in that I set the RecordSource at RunTime. I discovered that as part of the Open Sub, I was using a DISTINCT on the SQL statement. Removed that after eliminating the need for it in the underlying table, it works like a charm.

Thanks for your help.

Mike

Mike
EchoVue.com

FYI: SQL Server 2005 eliminates the 255 character limitation of SQL Server 2000 blob / memo fields.

mmcdonal

This is a bug that Microsoft has been intending to fix for a long time but has not gotten around to it. It's especially true when using the SendObject method to e-mail reports.

Supposedly, they fixed it

http://support.microsoft.com/kb/326605/en-us

However, I'm using Access XP and it STILL happens.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division