In a Grid I have 1 column which I would like to display the contents of a field "status" from table "events" as following:

If status=1
display 'OK'
If status=2
display 'Cancelled'
If status=3
display 'Did Not Attend'
etc etc

In the control source of the column I have entered:

iif(events.status=1,"OK," "), iif (events.status=2,"Cancelled"," "), iif(events.status=3,"Did Not Attend," ")

but I get an error message "The Data Source for This Object must be a Variable Object"

What am I doing wrong?