Simulated option group in report

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

Guest

Hello,

I need to re-create a survey input form as a report in order to print it out.
Now I have this problem that on the form, there's a yes/no question with 2
check boxes, one of which is bound to the field in the table, and the other
is unbound and programmatically updated to be the opposite of the bound
checkbox.
Unfortunately, I don't seem to be able to recreate that functionality in a
report since there are no events.

How can I do that short of creating a checkbox-option group in the report?

Thank you.
 
How about just printing out "yes" or "no" in the same calculated field in the
report? If the field is Boolean then you could use IIf([yesNoField] =
0,"No", "Yes")
 
Create your report in design view. There is a tool box on the icon bar and
it has a check box. You can create two check boxes, both with the same
source and then edit the control source.
Like this ---
=IIf([YourYesNoField]=0,-1,0)
 
Thanks a lot.

Any idea why I'm getting a

Syntax error (comma) in query expression '[IIf([YesNoField]=0,-1,0)]'?
 
Back
Top