Hide a field w/o data

[sullivan]

I am looking for a code or expression to hide a field in a report, if there is no data to display in it. I tried =IIf(IsNull[Field Name]),"") but this turns the field off completely. Is there any way to do this?

 

[Chris RR]

If you copied your "iif" into your question correctly, you have a syntax problem. You are supplying a value (in this case, "") for the function if the field is null, but nothing if it is not null. Try something like this:
Iif(isnull[Fieldname]),"",[FieldName])