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])
