|
Subject:
|
Truncated Memo field on Report
|
|
Posted By:
|
echovue
|
Post Date:
|
8/14/2006 9:52:01 PM
|
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
|
|
Reply By:
|
AccessMaster
|
Reply Date:
|
8/15/2006 12:06:42 AM
|
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
|
|
Reply By:
|
echovue
|
Reply Date:
|
8/15/2006 12:19:34 AM
|
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
|
|
Reply By:
|
echovue
|
Reply Date:
|
8/15/2006 12:38:18 AM
|
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
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
8/15/2006 6:34:42 AM
|
FYI: SQL Server 2005 eliminates the 255 character limitation of SQL Server 2000 blob / memo fields.
mmcdonal
|
|
Reply By:
|
SerranoG
|
Reply Date:
|
8/16/2006 8:52:17 AM
|
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
|
