If then

  • Thread starter Thread starter CAKDH
  • Start date Start date
C

CAKDH

i have a calculated field that is optional with a check box above. can i
have an if the check box is yes then do the calculation if the check box is
no then value is 0.00? what would be the expression?
 
CAKDH said:
i have a calculated field that is optional with a check box above. can i
have an if the check box is yes then do the calculation if the check box
is
no then value is 0.00? what would be the expression?
Click to expand...


Something like

=IIf([chkYourCheckBox], <your calculation here>, 0)
 
You will need to put that code in the OnCurrent event of the form and
in the afterupdate event of the checkbox.

Ron
 
You must log in or register to reply here.

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

Similar Threads

Validate the number of checkboxes that can be true 0
If calculation in text box > 1 hour set check box = True 2
Default value for a check-box 12
Can a Check Box Prevent Other Fields from Being Used? 1
Getting an UnBound control value into a Table field?????? 18
If "Yes" in check how do I show value and if "No" no value 1
Enter Parameter Value in Access Form 0
removing #Num! from txt box 7

Back
Top