By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,248 Members | 1,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,248 IT Pros & Developers. It's quick & easy.

errors in my calculation text box

P: n/a
hi,

I have a textbox ina report which references the textbox of another
subreport, the problem is that if teh subreport has no values, it
returns #error.

How do you check for this, so I can suppress the error in my displayed
report?

thx
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Try wrapping it in Nz.

=Nz(YourCurrentExpression, "")

--
Wayne Morgan
<ph*****@vistatec.ie> wrote in message
news:a3*************************@posting.google.co m...
hi,

I have a textbox ina report which references the textbox of another
subreport, the problem is that if teh subreport has no values, it
returns #error.

How do you check for this, so I can suppress the error in my displayed
report?

thx

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.