Formula displays Error rather than message

[XP]

I have the following formula in the Control Source of a report; the problem
is rather than "No Changes", it displays Error when this evaluates to true:

=IIf([RCD_NW]="Y","New Position",IIf([RCD_NW]="N","Change to Existing","No
Changes"))

Can some one please help me out with this? How can I get the third message
to display when RCD_NW is neither "Y" nor "N"?

Thanks in advance.

 

[Duane Hookom]

Does the control always display Error? If so, you may need to change the name
of the control to something like txtRCD_NW.

You might also look at the Switch() function which is easier to maintain
when you start nesting IIf()s. Personally, I would either create a lookup
table for the values and their titles or create a small user-defined function
to return the title based on the value of RCD_NW.

 

[Jan Kowalski]

Does the control always display Error? If so, you may need to change the
name
of the control to something like txtRCD_NW.

You might also look at the Switch() function which is easier to maintain
when you start nesting IIf()s. Personally, I would either create a lookup
table for the values and their titles or create a small user-defined
function
to return the title based on the value of RCD_NW.

--
Duane Hookom
Microsoft Access MVP

I have the following formula in the Control Source of a report; the
problem
is rather than "No Changes", it displays Error when this evaluates to
true:

=IIf([RCD_NW]="Y","New Position",IIf([RCD_NW]="N","Change to
Existing","No
Changes"))

Can some one please help me out with this? How can I get the third
message
to display when RCD_NW is neither "Y" nor "N"?

Thanks in advance.