How do I check a check box based on a field code?

[khughes46]

I have a report where I want to check one of three checkboxes based on a code in a field. For example if the code in the field is 0 I want to check, check box #1, if the code is a 1 I want to check, check box #2, if the code in the field is 2 I want to check, check box #3. I am using the check box in design view for the report and am assuming there must be some code in the control source. Can someone out there help me with this? Thanks.

[June7]

Try:

=[fieldname]=0

=[fieldname]=1

=[fieldname]=2

Or do calcs in query then bind checkboxes to the constructed fields.

[khughes46]

This worked very well, Thanks.