Setting the value "0" to "--"

[margaret]

In my report I have a control ... CYTotal: (Nz([cy1],0)+Nz
([cy2],0)) ... If the answer to this is "0", I would like
to use "--" instead. I tried using IIf statement and
couldn't get it to work ... any suggestions?

 

[fredg]

In my report I have a control ... CYTotal: (Nz([cy1],0)+Nz
([cy2],0)) ... If the answer to this is "0", I would like
to use "--" instead. I tried using IIf statement and
couldn't get it to work ... any suggestions?

Use the control's Format property.
Set the Format property to:
#;-#;--

See Access Help on:
Format Property + Number and Currency datatype