Stop randomly omitting text in reports
Sometimes, MS Access reports silently omit lines of text. This bug exists since at least Access 2007, and it's very annoying -- customers have to manually double-check every invoice to make sure that everything important has actually been printed.
The bug is well-known (see, for example, StackOverflow questions 10612364 and 14716048, SuperUser question 455782, MSDN thread 648dd3a2-28c1-4f0d-853c-ef932c58519f, or Microsoft Support Cases 114032111284860 and 115072312971316), but, apparently, has not been considered important enough to be fixed.
Thanks for reporting.
We will add this bug report to our backlog and see that it is prioritized and handled.
In the meantime, I’m updating the status for ‘No Current Plan’ so that you use your votes again.
I believe, for Rich Text formatted text boxes, it truncates text from the last line feed in the text box. My solution was to concatenate a line feed to the end of the text box. Here is my text box Control Source; (="Notes: " & [Comments] & "<br>"). I have not experienced the problem using Plain Text. Hope this helps!
Using Office 365 Access (up-to-date).
Long db table text field (plain text) containing >255 characters,
Report with text box 7" wide and 2" tall set to can grow and can shrink. Only first 255 characters are shown in the report in either print preview or report view.
Same db field displays all >255 characters in a form.
Jim Wright 2019-10-01
Jason Cox commented
I think I just hit this same pagination calculation bug.
Scenario sub report in a section both set to can grow. There is a page break control at the bottom of the section. It is conditionally made visible or not as a WORKAROUND to the fact that setting the visibility of the following section does NOT disable the Force New Page Before section not to fire.
The Page break happens at the end of page regardless of the fact the sub-report should cause pages to span. The sub report control and the page break control are not overlapping.
James Rezin commented
This does not just apply to one font, it applies to Arial as well. Also, I thought I had solved it by replacing the Bound textbox with an unbound one with a formula in it. It worked foe a couple of hours then reverted back to truncating the content again.
I am trying to build an application for a client and it is causing me enormouse amounts of extra work (bot budgeted for) and expending the go live date.
I tried to export to RTF but the Conditional formatting does not export with the data so no better off as Conditional formatting is key to the Application.
Please get this sorted, its been many years now that this has been a problem and is not really acceptable.
I'd like to see this fixed, too. Just as described in SO question 10612364 mentioned by Heinrich, it seems to be caused by using Calibri font in the report's page header section.
Jean Hsi Yin commented
Hi, I am using MS ACCESS 2013. textbox.cangrow fails if it's textformat is RichText. Please address this bug. Thanks.
I would like to add with an additional details about this problem. Version 2000 Report but would be the same for newer. An abnormal behavior of Formatting a calculated value in a Textbox. A standard without number formatting, the left most number with meet very close the the right side of the Textbox. With a calculated value formatting, the left most number will further away from the right side of the Textbox. With this odd behavior, I suspect it might also cause the Report to appear a blank area or misplace wordings to another page.
Sometimes reports omit a photo as well, for no apparent reason. Close the db, reopen and run the report, and that report works, but the same report for another record may be missing text/photo now...
John Schlick commented
Just got this with a client today. A rich text box isn't growing to show all the lines of text when printed on a report.