Blank fields in report replaced by text

  • Thread starter Thread starter SPK
  • Start date Start date
I have tried the follwoing expression in the control source property of the
report. which is giving an error mssg in the report.
=Nz(OD,"NA")

Can Anybody help.

Thanks
 
I have tried the follwoing expression in the control source property of the
report. which is giving an error mssg in the report.
=Nz(OD,"NA")

Can Anybody help.

Thanks
Click to expand...

Make sure the NAME of this control is not "OD".
What was the error message?
Is OD the name of the field?
Are you sure the field is Null and not a zero length string?
If OD is a Number datatype field, did you try setting the Format
property of this report control to:
#;-#;0;"N/A"
 
Back
Top