I have a multi line text box with edits captured, i want the most recent note in the text box to be displayed on a report when hovered over an image. Can this be done?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have field, text-multi line with edits captured, when i use this field in a report, the report looks shabby, So is there a way the most recent note be displayed when hovered over an image.

Photo of JW


  • 140 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Eric


  • 40 Points
Although the hover over portion would require JavaScript to work properly, here's a formula that would display the last comment and a "more..." link to display the full record for more details: List(" ",Right(Part([MultiLineTextField],2,"["),"]"),"<a href=\"" & URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#] & "\">more...</a>"). You can then include this field in your report, and users can click to see the full information in the field on the form.