checkbox in the footer area marked/unmarked

R

Robbie Doo

I need help with the checkbox at the bottom of the report to be either marked
on unmarked based on the checkboxes in the detail area. If all the checkboxes
are marked I want the Bottom Checkbox to be checked. If anyone of the
checkboxes is not marked I want the Bottom Checkbox to be blank. Any help is
appreciated.
 
S

Scott

put a hidden text field that says if check is true then 0 if not 1. Then
add the text field in your report footer. If the total is 0 then all checks
are true, if it is equal to 1 or more then you have atleast one negative
 
D

Duane Hookom

Add a check box and set the control source to:
=Sum(abs(YesNoField)) = Count(1)
 

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

Create form with checkbox les that expand and collapse sections of the form? 0
Generated text copies into another template 0
Checkbox marked or unmarked on a report 2
Adding a comment in a footnote area 1
How to make the shading look uniform around a double spaced line in MS Word? 0
fake checkbox based off lookup column 2
Template with fields and premade texts.. 0
Anything will help 0

Top