Text to Check Box on Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karen - 17 Mar 2005 17:15 GMT

I have a combo box on a form with two values that the user can select. On
the report that is based on this information, I would like the value that is
selected to appear as a checked check box.

Example:
The combo box is called Type of Complaint. The values are Quality of Care
and Quality of Service. Qualiity of Care has been selected. On the report,
I would like it to look like the following:

[X] Quality of Care [ ] Quality of Service (using check boxes)

Thanks for any assistance.

Reply to this Message

Marshall Barton - 17 Mar 2005 20:00 GMT

>I have a combo box on a form with two values that the user can select. On
>the report that is based on this information, I would like the value that is
[quoted text clipped - 6 lines]
>
>[X] Quality of Care [ ] Quality of Service (using check boxes)

You can use check box controls on the report by setting
their ControlSource expression to:
    =complaintfield = "Quality of Care"
    =complaintfield = "Quality of Service"

Or, possibly better looking, would be to use text boxes with
the expressions:
    =IIf(complaintfield = "Quality of Care", "X", "")
    =IIf(complaintfield = "Quality of Service", "X", "")

Signature

Marsh
MVP [MS Access]

Reply to this Message