IIF Statement in a report 1

[Tiggertoo]

In my report this is my control source. What I'm trying to get is if there is information in the field "content10" then the information is returned; if the field is blank then it returns "none." I'm getting "Error". What have I done wrong.

=IIf(IsNull([content10]),"none ",[content10])

 

[GoDawgs]

Your first post is correct (it should be IsNull(field) not the other way), but I'm thinking they aren't null values you're getting...probably zero-length strings. Try this:

=IIf([content10]="","none",[content10])

Hope that helps.

Kevin

 

[dhookom]

Try:
=Nz([content10]),"none&quot

Duane
MS Access MVP

 

[Jennifer252]

Make sure you don't have a textbox (or any other control) named content10.

Jennifer

 

[Tiggertoo]

I continued to get error messages so I ended up using
c10: IIf(IsNull([Content10]),"No comments.",[content10])
in my query. Then on the report my control source became "c10". Thanks for everyone's help anyway.

 

[OracleVictim]

I'm trying get a simple expression in the Access report writer to work properly. Essentially if I use:

=IIf([COMPLETION_CODE]="1","Conducted","Cancelled&quot

I get an error. Yet, if I run the following:

=IIf([COMPLETION_CODE],"Conducted","Cancelled&quot

I actually get the word "Conducted" to print. However, this is nonsense. Anyone have a clue as to why this is acting so odd?

OracleVictim

 

[dhookom]

COMPLETION_CODE must be numeric. You shouldn't compare it to the string "1". If COMPLETION_CODE is a numeric value other than 0, your expression would always return Conducted.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.