Using an Iif expression in a report

[jsfasman]

I have created a report with a control/field that usually posts a number, but I have added an IIf expression so the result is the word "STOCK" if the number is 99



=IIf([Change number]=99,"STOCK",[Change number])

I want to use an IIf expression in the same way on another control/field so the result is "ALL" if the number is 111

=IIf([Episode number]=111,"ALL",[Episode number])

However, every time I enter the IIf expression for the second control, I get an error message that it is a circular argument (Invalid control property; control source) and the result on the report is Type!

I have entered the expression by copying and pasting what I used on the first control, by using the expression builder and by just typing in the info. Why would this expression work on one control and not the other? Both have the same properties in the underlying table.

HELP!

[June7]

This can happen if the control has same name as a field used in expression.

[jsfasman]

This can happen if the control has same name as a field used in expression.

Thank you. It's working now. That was the one thing that I didn't check.