Larry's suggestion will show one column where it will actually say "Yes" or
"No" depending on the value of the checkbox in the table.
If I am wrong just disregard this. I understand your question to mean that
you want a YES column with check boxes and a NO column with check boxes and
the appropriate on checked. If this is the case then this is what I would
do:
1) In the design place two check boxes. Of course enter the labels with Yes
and No as appropriate.
2) in the Control Source for the Yes boxes put the following:
=IIF([thefieldname]=True, True, False)
this says: if 'thefieldname' is True (Yes) then make the YES check box True
(checked), if it is NOT True then don't check the box.
3) in the Control Source for the No box put the following:
=IIF([thefieldname]=True, False, True)
this says: if 'thefieldname' is True (Yes) then make the NO check box False
(unchecked), if it is NOT True (No) then check the NO box.
Sean
P.S. you could use the [thefieldname]=-1 to test if True as Larry showed
you, but I sometimes forget that '-1' means true sometimes so I just use
TRUE
Stanko Milosev said:
Thank you Larry for your quick response, can you be more specific, I
guess
I
shoud place that piece of code in a property, but which one?
Thank you once again.
Stanko.
Larry said:
-----Original Message-----
I have about 20 tables with yes no fields, data will be
entered in some, in
some will not. What I need is to show Yes and No field
separately, I mean if
user checked check box then it should show Yes field, if
user did not check
it, or it is not entered nothin I will have to show No
field checked in
report, how can you do that?
Thank you in advance,
Stanko.
.
=iif([FieldName]=-1,"YES","NO")
