Hi Guys
I am using the following control source property but when I run the report it gives me #Type error:
Any help will be much appreciated.Code:=IIf([Score]=1,"Yes","No")
Thanks
Hi Guys
I am using the following control source property but when I run the report it gives me #Type error:
Any help will be much appreciated.Code:=IIf([Score]=1,"Yes","No")
Thanks
you cant put IIF in textbox source.
you CAN put this home made field in the query behind the form, and the text box can be set to that.
ScoreYN: IIf([Score]=1,"Yes","No")
Yes Thanks, It worked like a charm.