Field value depending on the checkbox

[Robbie Doo]

I have a field that shows [Hours] depending if an employee was present or
not. And, the present is marked with a checkbox [Present]. But I want the
report to show all the employees' names but only the [Hours] that are NOT
[Present]. Any help is appreciated?

 

[Ofer Cohen]

On the OnPrint event of the section where the field are, you can write the code

Me.[Hours].Visible = (Me.[Present]=False)

To make the text box visible or not depend on the value in the check box