HowardDyer_III
9 months agoQrew Member
Report Formula - Strikethrough Text
I'm using a table report and would like to strikethrough the text all fields (columns) of an entry which has a [Project Status] that is "Cancelled". I've attempted a report formula (rich text) as follows:
Case([Project Status],
"Cancelled", "<span style='text-decoration:line-through'></span>")
I'm not receiving any errors in the formula, but there is no strikethrough text on the relevant "Cancelled" entries.
I've also attempted to specify a field, just in case the first formula wasn't specific enough, so I singled out [City ,ST | Site Name] with the same result (or lack thereof):
Case([Project Status],
"Cancelled", "<span style='text-decoration:line-through'>"&[City ,ST | Site Name]&"</span>")
Any help is greatly appreciated!
------------------------------
Howard Dyer III
------------------------------