CODEWITHSUNDEEP
ms-access-2013
Daniel Kohan
Daniel Kohan

Reputation: 1

Live field update in form in Access 2013

So I'm somewhat new to access 2013, anyways, I've created a form in access 2013 based directly off a table, so no queries involved if that matters, and what I'm trying to do is just have a text box that updates the total value of 3 different fields as they're entered.

right now it's just a plain-text box, the control source is "=[Search Cost]+[Update Cost]+[Copy Cost]", and if I close the form entirely and reopen the record it updates the text box with the total for all three, but the customer wants it to update in real time. Any suggestions?

Upvotes: 0

Views: 1464

Answers (1)

Jeff Conrad
Jeff Conrad

Reputation: 351

I just tried your scenario in Access 2013 on a simple form and it updated for me in real time as I entered values. However, that was because each of the three fields values had a Default Value of 0 in my test table.

So I suspect this is not updating for you in real time because one or more of those values is null while you are entering data in the form. Access doesn't know what [Some field value]+Null should be (it's an unknown thing) so it won't display a calculated value in real time on your form until you provide a value for each of the three fields.

So how can you get around this?

  1. You can add a Default Value of 0 or some other value to each of the three fields at the table level.

  2. Or you could modify your form expression to use the NZ function which will convert any null values to zero. So use this expression: =Nz([Search Cost])+Nz([Update Cost])+Nz([Copy Cost])

Either of those options should achieve your end goal I believe. They did in my quick tests.

Upvotes: 1

Related Questions