Check Box is checked depending on a data field?

[JohnD]

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

 

[ssteinke]

=IIf([status]="terminated";True;False)

try replacing ; with ,

 

[JohnD]

I love it when things work out

Thank you!!