If no data in rpt field print 0

  • Thread starter Thread starter andy
  • Start date Start date
A

andy

In a report we have a calculated field (numeric). I would
like to print a zero if there is no value (isnull?). Would
someone please tell me how to do this? And where do I put
the code snippet, in the control source attribute of the
property of the field? Or do I use the expression builder?
and if so again on what attribute of the property of the
field?

Thank you in advance
God bless you
 
Use the Nz() function. You can use it in either the Query
being used as the RecordSource for the Report or in the
ControlSource for the Control (i.e. TextBox) on the Report.

Check Access VB Help on the Nz() function.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top