Windows 10 
Office 365
Hello!
Thank you in advance for taking the time to read this and offer suggestions.
Situation
- I've created a shipping report that I export to PDF.
- In the details section of the report, I've got a field that is a hyperlink to the file on SharePoint. I create the link by concatenating two table fields in a way that works in PDFs (and in the report when viewed on screen). The end result for this field is basically: DocumentName#SharePointURL#. The user only sees the document name because the textbox control is Plain Text, but it behaves like a hyperlink (blue, underlined).
- I group my report on each shipment (data only, as there are no shipping labels on SharePoint that are stored in my database.) Hence: 1 shipment --> Many documents with hyperlinks to view the documents, if needed.
- This all works as intended.
- I'm now doing a new report for Approvals.
- It's very similar to the shipping report, with the difference being that I also have an approval letter that is stored on SharePoint.
- Each approval typically covers multiple approved documents, so I am grouping my report on the unique ApprovalID.
Issue
In creating the textbox to hold the Approval Letter data (ApprovalLetter#SharePointURL#), there are no problems when that textbox in the Detail Section of the report. But when I move that same textbox to the ApprovalID Header, the data in the textbox gets truncated and the hyperlink does not work as intended. It seems to be limited to 298-299 characters. The number of characters in these fields is often 350-400. Trying to troubleshoot, I put the same ControlSource in a new textbox in the Detail section of the report. It does not get truncated and the hyperlink works. I also tried changing the control to Rich Text. This did not help with the truncation issue and it changed the appearance of the data to be the full field.
Is this a known limitation? Is there a way to fix this?
Reply With Quote
Originally Posted by June7
