Don't show "0" value

[Elmobram22]

I have a report that I had set to not show 0 value when it was a number field. I have now changed the field to a text field (don't ask) but I need it still not to show thw value if it is 0. How do you do that?

Cheers,

Paul

 

[pr2-eugin]

Hello Elmobram22, In the criteria set the condition <> "0"

 

[Elmobram22]

Sorry, I didn't explain myself too well. For a change!

I want to show the fields but replace the "0" with ""

Cheers

 

[pr2-eugin]

You can use an IIF..

IIF(theFieldName = 0, "", theFieldName)