Blank fields in report replaced by text

S

SPK

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
 
F

fredg

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"
 

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

Replacing a phrase with carriage returns 1
Replace in a group or selection or collection of word files 1
Find and replace macro for Special ^p - MS Word 0
WORD VBA Search and switch to advanced ... 1
Word macro that can call cells out of Excel for a find and replace 0
Disable Outlook AutoCorrect with GPO 0
Prompt For Replace in Selection And More... 0
Matching literal text "???" in Word 2010 field code IF statement 2

Top