Check Box value from a form?

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I have a report based on a table. The table gets
information from a form. There are several yes/no
questions on the form. I would have preferred just a
check box for Yes, but I also need to add a No check box.
I prefer to leave redundant values out of a table, so I
used an unbound check box. I set its value to false in
order that it would appear white rather than gray.
However, I cannot find a way to refer to that check box in
the report. For that matter, I don't know if I am
creating unnecessary problems by using the unbound check
box in the form, but I would really like to avoid the
potential confusion of a Yes/No field in which Yes means
No, which would be the case with a No check box. Should I
be using an option group? I think I can figure out how to
do that, but I can't figure out if I should.
 
If you need to display both a Yes control and a No control then consider
using an option group. The value property of the Yes option should be set
to -1 and the No option value is 0. Bind the option group to the field in
your table. You can use the same display in a report.
 
Bruce said:
I have a report based on a table. The table gets
information from a form. There are several yes/no
questions on the form. I would have preferred just a
check box for Yes, but I also need to add a No check box.
I prefer to leave redundant values out of a table, so I
used an unbound check box. I set its value to false in
order that it would appear white rather than gray.
However, I cannot find a way to refer to that check box in
the report. For that matter, I don't know if I am
creating unnecessary problems by using the unbound check
box in the form, but I would really like to avoid the
potential confusion of a Yes/No field in which Yes means
No, which would be the case with a No check box. Should I
be using an option group? I think I can figure out how to
do that, but I can't figure out if I should.
Click to expand...


I think an option group would be a good idea in that
situation. The table field would then be bound to the group
instead of being bound to a check box. You can set the
OptionValue of the check boxes in the group to 0 for the No
box and -1 for the Yes box. This way your table's field
would still have the same values as it does now and the
report would not need to be concerned with how the stuff on
the form is arranged.
 
Thanks. I thought that was what needed to happen, but I
didn't want to venture into it without knowing.
 
I appreciate the help. I will get to work on option
groups, now that I know it makes sense in this situation.
 
Back
Top