Forum Discussion
LauraThacker
11 years agoQrew Captain
I use this code for these kinds of problems.
If(Length([Comments])>100,Left([Comments],100)&"...<br><a href="&URLRoot()&"db/"&Dbid()&"?a=dr&rid="&[Record ID#]&"&dfid=10>more</a>",[Comments])
Change the 100 to represent the number of characters that you need to display in the report before the "more" button becomes visible.
(Remember to turn on the HTML in the Formula Text field) - usually I label these fields [Comments (Reports)] so it is more obvious which fields should be used for report building
If(Length([Comments])>100,Left([Comments],100)&"...<br><a href="&URLRoot()&"db/"&Dbid()&"?a=dr&rid="&[Record ID#]&"&dfid=10>more</a>",[Comments])
Change the 100 to represent the number of characters that you need to display in the report before the "more" button becomes visible.
(Remember to turn on the HTML in the Formula Text field) - usually I label these fields [Comments (Reports)] so it is more obvious which fields should be used for report building