如何在没有VBA的情况下在计算控件中捕获#Error [英] How to Trap #Error within Calculated Control without VBA

问题描述

所以，那里有父母。形式和儿童表格。

这些工作非常好，所提取的信息是正确的;但是，我们希望在子表单上显示的条目之间经过的时间。


不是问题，我已经在报告和正常表单中做了很多次：

名为z_ctrl_txt_elapseddays的未绑定文本框

控制源是（我已经将其用于阅读）：

So, there''s the ole "Parent" form and "Child" form.
These work very well and the information pulled is correct; however, we want the elapsed time between entries that show on the sub form.

Not an issue, I''ve done this a ton of times in reports and on a normal form:
Unbound Textbox named z_ctrl_txt_elapseddays
The control source is (I''ve stepped this for reading):

展开 | 选择 | Wrap | 行号

推荐答案

Nn（）函数不起作用吗？

Wouldn''t an Nz() function work?

我建​​议使用 Nz （）。

No。

第二件事我尝试。

当表格被打开为独立时相反，如果作为一个子表单，该函数通过parent！子表单构造引用控件，该构造解析为#NAME错误，导致#ERROR


我甚至试过ME！[字段]在控件内构造，以确定它是否适用于V2010

No.
Second thing I tried.
When the form is opened as a "stand alone" instead if as a subform, the function refers to the control via the parent!subform construct which resolves to a #NAME error which results in a #ERROR

I even tried ME![field] construct within the control just to see if it would work in V2010

这篇关于如何在没有VBA的情况下在计算控件中捕获#Error的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！