I have a TextBox in the footer of my report that takes a column that can hold up to 5000 characters, but a TextBox in the footer cannot accept 5000 characters because of its size. In my tests, the TextBox displayed several characters between 1000 (the letters "M") and 1800 (dots).
I would like to create a new page if this field overflows, and I want the overflow part to appear in the footer of the next pages, thereby giving the column the proper space divided into two or more pages.
To summarize: instead of displaying the start of my oversized field in the footer text box on every other page, I want the entire content of the field to be populated in the footer of several pages.
Note. Determining the number of characters displayed on the first page and displaying the rest on other pages is not an option, because we cannot get close to accuracy when it comes to characters and using fixed numbers, since each character has a different length.
Note2: Is additional information required? I will describe it fully if you ask! leave a comment
source
share