Printing single text field as 3 check boxes

Y

Yeahyeahyeah

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
 
D

Duane Hookom

Add three check boxes to your report and set their control sources to:
=Rating="A"
=Rating="B"
=Rating="C"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top