IIF & check boxes

  • Thread starter Thread starter Art
  • Start date Start date
A

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
 
Me.CheckBox = True

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

HTH
Van T. Dinh
MVP (Access)
 
Back
Top