Writting an IIF statment as a validation rule

  • Thread starter Thread starter Rania Kilany
  • Start date Start date
R

Rania Kilany

I have a textbox that perform some calculation, at the control source i wrote
a statmen for calculating the value in this textbox = [value1]-[value2] and
it works

now i want to add a validation rule for this value as if it is lower than a
specific value it changes the color of the box or give me a messege

=IIF([Amount_left]< ([Estimation] / 2),"true","false")

i wrote this statment in the validation rule property but it doesn't work, i
don't know what is wrong ?

Thank you

Rania
 
"but it doesn't work, i don't know what is wrong" we don't either since you
didn't provide any sample data, results, or expect results.

You provided some control source for a text box but neglected to provide the
name of the text box.
 
Back
Top