Connecting Tech Pros Worldwide Help | Site Map

Report Truncation

Newbie
 
Join Date: Oct 2007
Posts: 8
#1: Nov 12 '07
I tried generating a report from a table that has more than one "memo" field. These fields are truncating on my report. I am able to get all fields that I want on the report, just not all the data within the fields. I also do not see where there is a field size option in the properties setting for the fields. Can anyone help?

Thanks
msquared's Avatar
Administrator
 
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,865
#2: Nov 14 '07

re: Report Truncation


Quote:

Originally Posted by jnice814

I tried generating a report from a table that has more than one "memo" field. These fields are truncating on my report. I am able to get all fields that I want on the report, just not all the data within the fields. I also do not see where there is a field size option in the properties setting for the fields. Can anyone help?

Thanks

The problem is not with your report. The query behind the report is truncating the memo fields to 255. Can you post the SQL of the query you are using?
Reply