Hidding error messages

[Guest]

Is there anyway to hide error messages? I have two field in my report that
are zero divded by zero issues. So I get #num! and then another field that is
based on the #NUM! field comes back as #error. it is only in those fields
that have zero as a value. I have access 97 so conditional formating is not
an option for me. Thanks

 

[John Spencer (MVP)]

Handle the condition that is causing the error by eliminating the problem. One
way might be using an IIF statement in your record source. Something like:

Field: DoTheMath: IIF(SomeField=0,0,AnotherField/SomeField)

 

[Terry]

Jason,

Try iif([sometimesZeroField]=0,"",normalCalculation)

This should display nothing if the offending field is zero.

HTH,

Terry

 

[Guest]

John,

Thank you very much. That should help. I don't know why I never though of it
Jay

 

[Guest]

Where do you type this calculation? I am working in a report that looks bad
with the #ERROR and #NUM in the middle of it. I have tried including it in
an expression but it is not working. Please help.

Jason,

Try iif([sometimesZeroField]=0,"",normalCalculation)

This should display nothing if the offending field is zero.

HTH,

Terry

-----Original Message-----
Is there anyway to hide error messages? I have two field in my report that
are zero divded by zero issues. So I get #num! and then another field that is
based on the #NUM! field comes back as #error. it is only in those fields
that have zero as a value. I have access 97 so conditional formating is not
an option for me. Thanks
.