Zero Default

  • Thread starter Thread starter DS
  • Start date Start date
D

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
 
Set the ControlSource to this:

=Nz(IIf(IsError([subreport].[report].[controlname]), 0,
[subreport].[report].[controlname]), 0)
 
Ken said:
Set the ControlSource to this:

=Nz(IIf(IsError([subreport].[report].[controlname]), 0,
[subreport].[report].[controlname]), 0)
Click to expand...
KEN!!!
God bless Ya, I've been banging my head against the wall for hours now.
It Works!!!! Thank you so very much.
DS
 
You're welcome.
--

Ken Snell
<MS ACCESS MVP>

DS said:
Ken said:
Set the ControlSource to this:

=Nz(IIf(IsError([subreport].[report].[controlname]), 0,
[subreport].[report].[controlname]), 0)
Click to expand...
KEN!!!
God bless Ya, I've been banging my head against the wall for hours now.
It Works!!!! Thank you so very much.
DS
Click to expand...
 
Back
Top