#Error in Iff statement

I am receiving a #Error message when I change the PName field to the
following
=IIf(Len([PName]=2),"-None Selected-",[PName]) in my report. The
PName is just a joining of Last and First Name with a comma and space
in between. I would like the report to say "-None Selected-" if No
Name was entered.
Any suggestions?

you have a closing bracket in the wrong place in the LEN function. Try this:

IIf(Len([PName]) =2 ,"-None Selected-",[PName])

John


wrote:
I am receiving a #Error message when I change the PName field to the
following
=IIf(Len([PName]=2),"-None Selected-",[PName]) in my report. The
PName is just a joining of Last and First Name with a comma and space
in between. I would like the report to say "-None Selected-" if No
Name was entered.
Any suggestions?

--
Message posted via http://www.accessmonster.com

On Tue, 13 Nov 2007 10:48:14 -0800, wrote:

I am receiving a #Error message when I change the PName field to the
following
=IIf(Len([PName]=2),"-None Selected-",[PName]) in my report. The
PName is just a joining of Last and First Name with a comma and space
in between. I would like the report to say "-None Selected-" if No
Name was entered.
Any suggestions?

Your parenthesis is misplaced.
Also, I'm not sure if the PName field can be null, so....

=IIf IsNull([PName]) or len([PName]) = 2, "-None Selected-",[PName])

You must also make sure the name of this control is not PName.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

On Nov 13, 1:58 pm, "J_Goddard via AccessMonster.com" u37558@uwe
wrote:
you have a closing bracket in the wrong place in the LEN function. Try this:

IIf(Len([PName]) =2 ,"-None Selected-",[PName])

John

wrote:
I am receiving a #Error message when I change the PName field to the
following
=IIf(Len([PName]=2),"-None Selected-",[PName]) in my report. The
PName is just a joining of Last and First Name with a comma and space
in between. I would like the report to say "-None Selected-" if No
Name was entered.
Any suggestions?

--
Message posted viahttp://www.accessmonster.com


That worked! THANKS!