Access 2007 不会自动更新带有绑定字段的计算

发布于 2024-09-12 14:40:14 字数 498 浏览 6 评论 0原文

我开发了一个 Access 2003 数据库，其表单具有许多绑定的输入文本字段。当用户更新这些字段中的值时，表将使用更改后的值进行更新。我还有一个未绑定的文本字段，用于显示用户输入的计算值。这不使用表单上文本字段中的值，而是直接使用表中的值。

该文本字段的控制源类似于：

=[field1]+[field2]+[field3]

与 Access 2003 中不同

=txtInput1.value+txtInput2.value+txtInput3.value

，计算的文本字段会在用户更改绑定的输入字段时自动更新。然而，一些用户使用 Access 2007，他们不会自动更新计算字段，除非他们重新加载表单。

仅当我使用输入文本字段而不是绑定字段来执行计算时，它才会自动更新。

我在安全警告中选择了“允许此内容”。我还能做些什么来使其像 Access 2003 中那样运行吗？

谢谢

原文

I developed an Access 2003 database with a form that has a number of bound input text fields. As the user update the value in these fields, the table is updated with the changed value. I also have an unbound textfield that displays a calculated value from the user input. This does not use the values from the textfields on the form, but directly from the table.

The Control Source of this textfield is something like:

=[field1]+[field2]+[field3]

Rather than

=txtInput1.value+txtInput2.value+txtInput3.value

In Access 2003, the calculated textfield get updated automatically as a user changes the bound input fields. However some of the users are using Access 2007 and they don't get the calculated field updated automatically, unless they reload the form.

It only updates automatically if I use the input textfields rather than the bound fields to perform the calculation.

I have selected "Allow this content" in the security warning. Is there anything else I can do to make it behave like in Access 2003?

Thanks

分享到QQ

分享到微博