Strikethrough

[wodonnell]

Is there any way of setting the strikethrough property of a font used on a report.

I would like to be able to "cross out" certain values on a report if certain criteria are met.

I have been able to change the actual font, or the size or set bold/italic/underline, but there does not appear to be any way to set strikethrough.

One workaround I thought of was to have a transparent textbox over my actual textbox and to fill this with "-"s or "x"s or something if the criteria was met but this (a) looked messy, and (b) means a lot of work when there are a lot of fields to be "crossed out".

Any ideas?

 

[Rich]

Are you croosing through the whole record based on a certain condition?

 

[wodonnell]

Example of report (my actual report is quite a bit more complex than this but this should give the basic idea):


Firm | Date of Application | Status
---------------------------------------------------
My Firm | 11-10-2003 |
firm 2 ltd | 10-09-2003 | Accepted
Three co | 10-09-2003 | Rejected

To simplify things a little from what I am actually doing -
say I wanted to italicise the rejected firms, I have created an event on the "Detail" section of the form which states:

if status="Rejected" then
firm.fontitalics=true
appdate.fontitalics=true
status.fontitalics=true
else
firm.fontitalics=false
appdate.fontitalics=false
status.fontitalics=false
end if

This makes all entries for the rejected firms be italics whilst firms with any other status are normal text.

What I would like to do is rather than have the row in italics, have it with a line through the text parts.

(I had tried having a simple line which went through the entire row and simply did a line1.visible=true or false depending on the criteria but as the report contains lines and a grid this looked a bit confusing.)

 

[wodonnell]

I have opted for simply changing the text color to a light grey. This way it is easy to see at a glance which records are important and which can be ignored, but also the "rejected" records are still fairly easily readable.