Checkbox marked or unmarked on a report

R

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?
 
O

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)
 
R

Robbie Doo

Thank you very much

Ofer Cohen said:
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)
 

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

Top