validation rule isn't working

[AlexD]

I enter some value into textbox1 and taxtbox2 on my form.
In textbox3 I have [textbox1] - [textbox2].

I tried to set up validation rule for the textbox3 such as

=0 but it's not working.

Can you help, guys.

 

[DebbieG]

Try

=Nz([textbox1], 0) - Nz([textbox2], 0)

Debbie


I enter some value into textbox1 and taxtbox2 on my form.
In textbox3 I have [textbox1] - [textbox2].

I tried to set up validation rule for the textbox3 such as

=0 but it's not working.

Can you help, guys.

 

[Allen Browne]

Are these unbound text boxes?
If so, the Validation Rule will not be applied, since Textbox3 is getting
its value programmatically (not by user entry).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I enter some value into textbox1 and taxtbox2 on my form.
In textbox3 I have [textbox1] - [textbox2].

I tried to set up validation rule for the textbox3 such as

=0 but it's not working.

Can you help, guys.