Using IIF in the Control Source 1

[sjh]

Hi,

In my report, I have a text box. Depending on the value of a field [highway], I would like to change what's being displayed. This is the Control source.

=IIf([highway]="Unknown", "*", [highway])

But when I run the report, I get the "Error #".

What am I doing incorrectly???

Thanks for your help!
SJH

 

[GingerR]

is your text box named "Highway"? if so, change the name to like Highway1. for some reason it doesn't like it when the name of the text box is the same name as the field if you have a calculation in the text box.