Checkbox marked or unmarked on a report

[Robbie Doo]

Is there a way to show a checkbox in the report footer marked or unmarked
depending on other values? To clarify further, I need the checkbox to be
marked if all the employees were present on a particular day and to be
unmarked if anyone of them was absent. Is it possible?

 

[Ofer Cohen]

First, it can be done

It's hard to give you a direct answer on how to do it, because I don't know
how you want to check the values

It can be done by using the Report OnPrint event of the report footer

If Criteria Then
Me.CheckBoxName = True
Else
Me.CheckBoxName = False
End If

Or, to make it shorter
Me.CheckBoxName = (Criteria)

 

[Robbie Doo]

Thank you very much

First, it can be done

It's hard to give you a direct answer on how to do it, because I don't know
how you want to check the values

It can be done by using the Report OnPrint event of the report footer

If Criteria Then
Me.CheckBoxName = True
Else
Me.CheckBoxName = False
End If

Or, to make it shorter
Me.CheckBoxName = (Criteria)