Text to Check Box on Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Karen said:
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)
Click to expand...


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", "")
 
Back
Top