[MS_AccessPros] Re: Expression Builder Frustrations with IIF statement

 

Thanks for the reply Bill,

Control name is Corrective Action Taken. I used the:
=IIf(Len([CorrectiveActionTaken]& "")<>0,"X","Not Complete")

but I still get the #Type! error? Could I have somethings else wrong?

Thanks again, Rohn

--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Rohn
>
> First, make sure the control name is not CorrectiveActionTaken as that would cause a circular reference.
>
> Next, CorrectiveActionTaken could be null so check for that as well.
>
> =IIf(Len([CorrectiveActionTaken]& "")<>0,"X","Not Complete")
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
> My nothing-to-do-with-Access blog
> http://wrmosca.wordpress.com
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "Rohn" <reverson@> wrote:
> >
> > Thanks in advance!
> >
> > On an existing report. I would like to add an identifier, instead of picking the Field from the Control Source I want to add an expression if the field has data; place an X on the report or if field is blank/null place a statement "Not Complete".
> >
> > I have tried: =IIf(([CorrectiveActionTaken]=""),"X","Not Complete") but each variation I attempt I get #Type! or #Name or some other error. Do you know what I am doing wrong??
> >
> > I am using Access 2010.
> >
> > Thank you, Rohn
> >
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 4
• New Files 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___