IIF & check boxes

[Art]

Hi again
Inside a form, I'm trying to calculate a total (hours *
rate). Works fine. I'm trying to add an IIF statement to
determine the status of a checkbox. If the checkbox is
checked, hours*rate*discount, otherwise hours*rate. How
do I determine the value of the checkbox? I know that in
VB, Textbox.Checked = True works. However, I can't find
anything in Access in the textbox's properties that is
similar. Any suggestions?

TIA

Art

 

[Van T. Dinh]

Me.CheckBox = True

where CheckBox is the name of your CheckBox Control (NOT
TextBox).

HTH
Van T. Dinh
MVP (Access)