Simulated option group in report

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.
 
G

Guest

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")
 
G

Guest

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)
 
G

Guest

Thanks a lot.

Any idea why I'm getting a

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

Guest

Never mind, that was due to an operator error. :)
It's working perfectly.

Thanks again.
 

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

Similar Threads

Simulated option group problem 4
NULL 7
oPTION Group Coding 5
How can I change the sort order on report. 2
Toggle Button not refreshing 1
report order 4
Option Group 2
Report field change on the fly 2

Top