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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
BT PSTN to be switched off by 2025 6
Replace blank fields with 0 1
Ignore blank lines in report text box 3
blank fields on a name line 2
CanGrow with Memo fields? 2
How to hide a text field label when the field is null? Access2003 3
How do I suppress blank lines in reports 1

Back
Top