"<div style=\"width:10px;\"> "& Left(Right([Comments],"["),0) &"</div>"&
"<a href='"&Dbid()&"?a=dr&rid="&[Record ID#]&"' title='"&[Comments]&"' target\n=\"_blank\" \"> Comments</div></a>"
However, due to an html-related limitation as I understand it, the comment shown upon hover is cutoff at the first appearance of an apostrophe (or single quotation). For example:
Hover only displays:
Documents to be sent to buyer's Florida address
Documents to be sent to buyer
Documents rec'd from seller 1 but not seller 2
One suggestion I found to resolve this was to use the SearchAndReplace function to replace the apostrophes with a character that html will allow:
var text apost = SearchAndReplace([Comments],"'","");$apost
To be quite frank, I had no idea where to enter this…so I created another field, titled "Comment Transponder" (Formula – Rich Text). It does not appear on reports or forms, and serves only as a relay to remove the single apostrophes so that the apostrophe-less text can then be shown in full upon hover.
Comment Transponder Field says:
Hover now shows:
Documents to be sent to buyers Florida address
Documents recd from seller 1 but not seller 2
Is there a more efficient way to do this (that would eliminate the need for the Comment Transponder field)?