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

C

Chip

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!!!!
 
F

fredg

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")
 
R

Rick B

I would use the Nz function. It assigns a value in place of null.

Use the help files for more info.

Rick B
 
R

Rick B

Also, an if statement would work, but make sure you are using
IF(isnull([somefield]...
 
Top