Text box calc

[deen]

Hi all

I have doubt in below

code amt1 amt2 balance(text box)
001 500 500 0
002 1000 700 300

in access formula like =[amt1]-[amt2] this is the formula i was used
in text box, in that all the calculation is happen but 0 value is not
displayed in tht text.it shows error like.

Error:

One or more values are prohibited by the validation rule '=[amt1]-
[amt2]' set for 'paid details'. enter a value that the expression for
this can accepted,

i am new bie to access, any one can help me on this.

Regards,

Deen

 

[deen]

hi

What Am trying to say,
in text box i need to display the calculation amt1-amt2,

its working fine , but i am facing problem in weather the both value
(amt1 and amt2)is same means, i need to display in text box as
0(zero). weather i was enter the same amt in amt1 and amt2 column it
shows error

Your command of English is such that it is difficult to understand excatly
what you're saying, but going by the error message:

One or more values are prohibited by the validation rule

'=[amt1]-[amt2]' set for 'paid details'.  

would indicate that you have a validation rule set for a field called 'Paid
details' that says "'=[amt1]-[amt2]." This is not a legitimate validation
rule.This is the kind of thing that belongs in the 'paid details' Control
Source Property, assuming that you want  Paid details to equal [amt1]-[amt2].

On the chance that [amt2] should be left blank instead of the user entering o
(zero) you need to use something like =Nz([amt1], 0) - Nz([amt2], 0).

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200807/1