Setting the value "0" to "--"

  • Thread starter Thread starter margaret
  • Start date Start date
M

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?
 
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?
Click to expand...

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

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