Controlling Text Box Overflow

  • I have a situation in which I have a text box in a report that I do not want to increase in height but that will display text that almost certainly will overflow the available space. I would like to know if it's possible to set the text box to allow the user to click on the box and scroll right to read the rest of the text, rather than just truncating the text at the limit of the box width. Is this even a thing.

    Alternatively, placing an ellipsis at the end of the visible text and displaying some other way. Or even putting the full text into a tool tip so they can read it if the hover over the box. ?

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • You cannot setup a text box in a report where the user can scroll to the right - however, there is a technique you can use:

    1. Set the text box so it cannot grow
    2. Set the tooltip value - which will allow the user to hover over the text box and see the full results.

    You could also set the text box to an expression that only shows xx number of characters using substring - however, if you do that then exporting the data will not include the full text.

    You may need to adjust the line spacing for the text box - or the vertical size or placement.  The text will wrap and you want to avoid seeing part of the next line in the text box.  If you set the textbox alignment to bottom you won't see the next line, but if you set it to middle you could - for that just adjust the line spacing so the wrapped line does not show.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply