iif error??

[mgp]

Hello!

I'm using a2k and can't seem to figure out why a simple
iif statement doesn't work for me. Here is what I am
trying to do ... simply change the code to a description.
i.e. "c" = "coconut" or "s" = "strawberry".
A shorter version of my logic in a "text box.data.control
source" is:

=iif ([detail] = "c", "coconut", iif([detail]
= "s", "strawberry"))

This results in an #error

If I use the [detail] only ... the result is C or S. If I
use ="test" & [detail] ... I get an #error.

What am I doing wrong?

mgp

 

[mgp]

My appologies ... I found out the problem by changing
the 'detail' name to something else ... I keep on
forgetting to check for reserved words.

mgp