How do i use "If then statement" in an ACCESS report field to pri.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that can spit out some "Null" fields on the report but i want
to print "Blank" if the field is null. I thought a IF THEN Statement would
work but cannot seem to get anything to work. Can anyone assist me with
this? THANKS IN ADVANCE!!!!
 
I have a report that can spit out some "Null" fields on the report but i want
to print "Blank" if the field is null. I thought a IF THEN Statement would
work but cannot seem to get anything to work. Can anyone assist me with
this? THANKS IN ADVANCE!!!!
Click to expand...

Set the control source to:
=Nz([FieldName],"Blank")
 
I would use the Nz function. It assigns a value in place of null.

Use the help files for more info.

Rick B
 
Back
Top