The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Function AvoidError(n As Variant, varReplaceWith As Variant)
10 On Error GoTo AvoidError_Error
20 AvoidError = Nz(n, varReplaceWith)
AvoidError_Exit:
30 Exit Function
AvoidError_Error:
40 AvoidError = varReplaceWith
50 Resume AvoidError_Exit
End Function
and then change the reference in your report to:
=AvoidError(<subreport reference here>, "N/A")
Jim.