ms-access-2013 - UNbound Text Box wont save

Question

I have a form onto which I have placed an unbound text box. This box is designed to calculate the total of 4 other bound text boxes which have simple numerical values in. I have used the expression builder in the unbound text box to set its control source property i.e. =([box1]+[box2]+[box3]+[box4])

When I first put this in it works fine. However after I close and then reopen the data base the box sits on the form saying #NAME? as if it has lost its control source. I have checked the data source after and nothing seems to be wrong. Any ideas why its happening. Its a pain as I have a button which when pressed opens a report based on the value in the unbound text box.

标签： ms-access-2013

Answer 1

不完全确定为什么它现在可以工作，但我已将文本框和计算重新添加到源代码中，它似乎很好。也许只是我之前尝试中的一个小故障......我使用了 =sum 解决方案而不是 =Nz 解决方案。也许我的访问版本或我的数据库只是变化无常...无论如何谢谢