Calculated field and Null Value (1 Viewer)

Gavx

Registered User.
Local time
Today, 22:10
Joined
Mar 8, 2014
Messages
151
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

AWF VIP
Local time
Today, 11:10
Joined
Jul 26, 2013
Messages
10,354
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.
 

Users who are viewing this thread

Top Bottom