get a form check box to display a number in a report

E

ekim yeldarb

I want to use a check box on a form which will display a number when I run a
report from the table the form is linked to
 
W

Wayne Morgan

What sort of number do you want it to display? A checkbox is a Boolean
control, so getting -1 or 0 to display is fairly easy. Is this what you want
or are you wanting a count of true records? If the latter, try using
DCount() and make the report textbox a calculated control.
 
F

fredg

I want to use a check box on a form which will display a number when I run a
report from the table the form is linked to
Click to expand...


You haven't given a heck of a lot to go on here, so maybe this will
help:

=IIf(forms!FormName!CheckBoxName = -1,A number value,"")

and then, maybe not!
 
Top