I'm not sure if this is possible - I would like to have a conditional type formating on a field in a continous form, which will give the font colour of the field a transparent colour, so that the result is hidden.
I would like to do this to hide out a bunch of zero values. So far, I've tried setting the font colour to white on a zero value, but my odd lines have a light grey background, so it's still showing there. Is it possible to have a transparent font color, or to match it to the background colour of the line it's on?
If it's invalid for you to have 0s in the your results, don't refomat the colour to hide them, rewrite the query to exclude them / replace them with a blank or null value. If 0 is a valid result, then you shouldn't hide it, even if it looks ugly.