I have a report that, when a Text Box is in the Page Footer shows all of the required text, but when it is in a Group Footer it truncates the text after 3 lines, there being some 16 lines, in total, split into 3 parragraphs. Line 3 is in the middle of the first parragraph.
The data for the report is supplied by a query and the text for the Text Box comes from
[msg0] & Chr(13) & Chr(10) & [msg1] & Chr(13) & Chr(10) & [msg2] & Chr(13) & Chr(10) & [msg3] AS [Text]
Any ideas why this would work in one are of a report and not in another?
Access 2007. 2000-2003 format database.
The data for the report is supplied by a query and the text for the Text Box comes from
[msg0] & Chr(13) & Chr(10) & [msg1] & Chr(13) & Chr(10) & [msg2] & Chr(13) & Chr(10) & [msg3] AS [Text]
Any ideas why this would work in one are of a report and not in another?
Access 2007. 2000-2003 format database.