Null SubReport in calculation

[Val]

Help,

I have a supreport that calculates the sum of $.
Sometimes it returns Null.

The subreport is part of a calculation on the report and
when the subreport is Null, the calculation return #Error.
Unfortuneately, Access 2002 has a bug with the Nz() and
whenever I test the IsNull() or IsNumeric() it's always =
0.

How do I adjust my calculation so when the subreport
returns Null, it sees 0?

Or
How do I change the format of my currency field to a
string so I can try to see if Len(x)=0?

Thanks!

 

[david epsom dot com dot au]

1) It doesn't return NULL - that is why IsNull does
not return the result you expect.

2) The whole subreport is missing when there is no
data for the subreport. Any reference to the subreport
will return an error.

3) You can put code behind the report to do the calculation.
In your code you can ignore errors.

(david)