checkbox value true in report

[Guest]

Here's my problem. I have a checkbox on a report but I want the checkbox to
be checked only if all the items in another field are correct. If any of them
are not correct I don't want the checkbox marked.
Can anyone tell me how to fix this on a report?

 

[Rick Brandt]

Here's my problem. I have a checkbox on a report but I want the
checkbox to be checked only if all the items in another field are
correct. If any of them are not correct I don't want the checkbox
marked.
Can anyone tell me how to fix this on a report?

Define "correct".

Depending on the complexity of determining that you might be able to use an
expression as the ControlSource of the CheckBox (when not so complex) or you
might need to use code in the format event of the report section where the
CheckBox resides (when more complex).

 

[Scott]

I would have a hidden text box for each "other field" then have the control
for the text box set to if correct =0, if wrong =1 then add all the text
boxes up in the control for you check box and if = 0 check, >0 don't check