mkelly
Registered User.
- Local time
- Yesterday, 20:38
- Joined
- Apr 10, 2002
- Messages
- 213
I have a text boc on a report and the control source is:
=([text135]/[text138])
However sometimes text135 and 138 will be 0
How can I change the control to be blank in this instance instead of
"#NUM!"?
Also I set the decimal places to 2 and still get 6 or 7 decimal places is there another way to restrict that?
All help appriciated!!
=([text135]/[text138])
However sometimes text135 and 138 will be 0
How can I change the control to be blank in this instance instead of
"#NUM!"?
Also I set the decimal places to 2 and still get 6 or 7 decimal places is there another way to restrict that?
All help appriciated!!