Zero Default

[DS]

How do you set a Zero default to an Unbound field if the amount that is
to be in the field is coming from a control on a Sub-report that has no
records in it?
Thanks
DS

 

[Ken Snell [MVP]]

Set the ControlSource to this:

=Nz(IIf(IsError([subreport].[report].[controlname]), 0,
[subreport].[report].[controlname]), 0)

 

[DS]

Set the ControlSource to this:

=Nz(IIf(IsError([subreport].[report].[controlname]), 0,
[subreport].[report].[controlname]), 0)

KEN!!!
God bless Ya, I've been banging my head against the wall for hours now.
It Works!!!! Thank you so very much.
DS

 

[Ken Snell [MVP]]

You're welcome.
--

Ken Snell
<MS ACCESS MVP>

Set the ControlSource to this:

=Nz(IIf(IsError([subreport].[report].[controlname]), 0,
[subreport].[report].[controlname]), 0)

KEN!!!
God bless Ya, I've been banging my head against the wall for hours now.
It Works!!!! Thank you so very much.
DS