Writting an IIF statment as a validation rule

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.

--
Duane Hookom
Microsoft Access MVP


"Rania Kilany" wrote:

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