If NULL then N/A If NULL then N/A ptrifile (TechnicalUser) (OP) 23 Jan 17 14:59 I have a simple field in a report that I am trying to have show "N/A" if the field is blank. I am currently simply using CODE=Avg([days]) I have tried a few variations but cannot seem to get it right using the =IIF(IsNull...function. Any help is appreciated. Thank you, Paul RE: If NULL then N/A dhookom (Programmer) 23 Jan 17 18:40 You should be able to simply use the format property without messing around with the control source: CODE --> PropertyFormat: $#,##0.00[Green];($#,##0.00)[Red];"Zero";"N/A" Duane Hook'D on Access MS Access MVP RE: If NULL then N/A ptrifile (TechnicalUser) (OP) 24 Jan 17 14:47 Thanks dhookom! I used CODE0.0;($#,##0.00);;"N/A" and I got the desired results. Thank you for the help!