Calculated field and Null Value

[Gavx]

I am trying to add the value of two text boxes, whose default value is set to 0, by putting this statement in the record source of a third text box;
=-[txtTtlRent]+[txtBodyCorp]

However nothing displays in the third text box.

What is the problem? Note that the data types are correct.

Thanks

 

[Minty]

If either of the values are null on load then the result will be null.

0 + Null = Null

You may need to requery / refresh the values after form load.

 

[isladogs]

You may find this thread useful
https://access-programmers.co.uk/forums/showthread.php?t=297022

For your purposes, only the last 2 posts are relevant #26 & #27