View Full Version : Hiding Fields With "$0.00" data


KarenS
01-04-2006, 04:41 AM
Hi,
I want to hide fields on a Payslip report which contain $0.00

I have read through similar cases which hide empty fields, but they do not work for me - maybe because the fields display a zero balance.

Is there a way to do this

Any help is greatly appreciated - and by the way I am a beginner!!

KenHigg
01-04-2006, 04:46 AM
Can you do this with conditional formatting?

KarenS
01-04-2006, 05:10 AM
what do u mean?

KenHigg
01-04-2006, 05:33 AM
Right click the text box and tinker with the 'conditional formatting' option. You should be able to set the font color to white if the value = 0...