Hiding Zero Value in report field.

[cap.zadi]

Hi

I have some calculated Txt fields at the bottom of the report as the value in Control Source is

=(Nz([AccessTotalsField1],0)/Nz([TxtTotalField],0))*100

So its obvious that if there is no numbers in numerator field then it will show results in 00.00. So i want hide the zero values not the field.

Regards

[CJ_London]

use the format property

numbers have 4 potential formats - positive, negative, zero and null, each separated with a semi colon. so perhaps something like

#;#;""

[ranman256]

hide the txtBox with your value above, but show this result in txtBox2:
=IIF(txtBox=0,null,txtBox)

[cap.zadi]

Hi

Thanks and this format suggestion works fantastic.

[CJ_London]

you can use the format property to prompt for entering values - can simplify your form layout e.g.

#;[RED]#;"";[BLUE]"Enter a Value"