Forum Discussion

JaimeStrawderma's avatar
JaimeStrawderma
Qrew Cadet
6 years ago

Hover Over Text Field

I have text fields with unlimited character length. Due to my layout the fields are only a certain width. Is there a way to create a hover over option to reveal the full amount of text in the field? Thanks in advance.

------------------------------
Jaime
------------------------------
Formulas and functions
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    6 years ago
    I use this.

    If(Length([Notes])<180,[Notes],Left([Notes],180)&"<br><a href='"&URLRoot()&"db/"&Dbid()&"?a=dr&rid="&[Record ID#]&"&dfid=10' title='" &
List(" ",Part([Notes],1,"'"),Part([Notes],2,"'"),Part([Notes],3,"'"),Part([Notes],4,"'")) &
"'>more</a>")​
    You can change the 180 to any value.

    This formula will show the # of characters you specify unless there are less characters than the number you specify, in which case it shows all.  The more option shows up and display in a hover-m​​odal .

    ------------------------------
    Laura Thacker (IDS)
    laura@intelligentdbs.com
    (626) 771 0454
    ------------------------------
    • EricFixler1's avatar
      EricFixler1
      Qrew Trainee
      6 years ago
      Laura - this works great.  One limitation I have found is that if the notes field is long it cuts off the text in the hover field. 

      How do I extend that hover box to include more characters?

      I have tried to add ,Part([Notes],5,"'" , but that doesn't seem to do the trick.

      Thanks.
      Eric

      ------------------------------
      Eric Fixler
      ------------------------------
      • AdamKeever1's avatar
        AdamKeever1
        Qrew Commander
        6 years ago
        I think this is the limitation of the title attribute. It is used to show additional information about a link so that the user can learn more before clicking on the link. There may be a work around, but I am not aware of one yet.

        ------------------------------
        Adam Keever
        ------------------------------