If no data in rpt field print 0

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
 
V

Van T. Dinh

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)
 
Top