Printing single text field as 3 check boxes

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

Guest

Hi,
I have a form that uses a drop-down value list to fill in the RATING field
with the following values: 'A', 'B' or 'C'. When I print a report based on
this form, rather than having a single text box for RATING that displays one
of the three variables, I need the report to display all three values 'A',
'B' and 'C' with a check box next to each. The value that has been previously
selected from the value list will trigger either a check or an 'X' to be
placed in one of the three check boxes. So how do I make this happen?

thanks,
David
 
Add three check boxes to your report and set their control sources to:
=Rating="A"
=Rating="B"
=Rating="C"
 
Back
Top