Check Box Is Checked Depending On A Data Field?

I have a data field (status) that is either Graduated, Terminated, or Current. I also have a report that has a check box representing each (such as a check box for graduated and another for Terminated etc).

I am trying to get the report to read the status and check the appropriate box in the report.

I have tried this in the control source of the checkbox
=IIf([status]="terminated";True;False)
but this does not work

I have also tried this on the OnOpen

If [status] = "terminated" then
termcheck = true
else
termcheck = false
end if
end sub

But this does not work either - what am I doing wrong :confused: