asked on

Report Field Truncated

There is a report in our database where the data of a particular field is getting truncated (e.g. sentence is getting cut off). This is a memo field in the underlying table. I read a few posts that say Memo fields will get truncated in list or combo box in MS Access. I also read the following troubleshooting post: http://allenbrowne.com/ser-63.html. However, what I don't understand is that the data is in an MS Access report. I'm not trying to export it. Does anyone have a work around? Or is this really the issue for the sentences getting cut off? Thanks,

eklin

ASKER

Note that "Can grow" is enable on field and sections of the report

eklin

ASKER

I just noticed that the form is actually sourcing the data via a query. When I execute the query it comes truncated, so it appears the problem is with the query....

SELECT 1 AS ShortType, '' AS Category, '' AS CategoryName, tblShortHeaderQA.QuestionOrder, tblShortHeaderQA.Question FROM tblShortHeaderQA UNION (SELECT 2 AS ShortType, tblShortQuestionnaireTemplate.Category, tblShortCategory.CategoryName, tblShortQuestionnaireTemplate.QuestionOrder, tblShortQuestionnaireTemplate.Question FROM tblShortQuestionnaireTemplate INNER JOIN tblShortCategory ON tblShortQuestionnaireTemplate.Category = tblShortCategory.CategoryID ORDER BY tblShortCategory.CategoryOrder, tblShortQuestionnaireTemplate.QuestionOrder);

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

eklin

ASKER

Thanks Rey! It seems to have worked. I'll do more checking prior to closing the issue. I replaced the UNION with UNION ALL as suggested by the post... I