Strikeout text in a report based on field value

[Former Member]

I'm trying to find a way of striking through the text in a row in a report depending on a field value (i.e if value = 'CANCELLED' then strikethrough). The Highlighting Expert doesn't seem to allow strikethrough. Can anyone suggest another way of doing this ?

[abhilash_kumar · Accepted solution]

Hi Peter,

Right-click the field > Select Format Field > Font tab > Click on the Formula button beside 'Strikeout' and use this code:

currentfieldvalue = "CANCELLED"

Hope this helps.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash

Thanks for the prompt response. Do you know how can I get this to work if the column I want to strikethrough is not the one that contains the status value. The column I want to strikethrough is called 'Title' and the column I'm checking is called 'Status'. If 'Status' = CANCELLED then I want to strikethrough the title.

[abhilash_kumar · Accepted solution]

Yes, modify that formula to:

{Status} = "CANCELLED" //Replace Status with the database field

-Abhilash

[Former Member · Accepted solution]

Thanks Abhilash

Just what I needed