Displaying Check Boxes on Report (1 Viewer)

[connieharper]

I have a school report that must display 6 check boxes, each with a different label. (New, Transfer, Graduate, etc.) What I want to happen is this: I want a check mark to appear in the whichever box applies to the status of the particular student whose record is being printed.

I have included the field from the student's record that contains the status information in my report query but do not know how to look at that data and then put a check mark in the correct box on the report. Can I add an IIF statement to the control source on each check box and have it look at the student's record to determine if a check mark should appear? If so, what is the syntax?

My table name is [student records] and field name is [type].

Thanks

 

[Fornatian]

Try this is the control source:

=IIF([Status] = "WHATEVER STATUS IM TESTING FOR",[Type]=True,[Type]=False).

For each check box you'll have to imput this in the control source and change the text to whatever the status you're testing for.

Hope this works.

Alternatively, if you just want to segregate different types of students you could build a report that groups the student into their appropriate types.

Ian