摆脱#Error [英] Getting Rid of #Error

问题描述

你好，


如果没有数据，我需要帮助摆脱表格中字段中的#Error。我使用下面的公式：


="" &安培; [系统]


当#Error显示我切换到


= IIf（IsNull（[System]），"" ，[系统]）


，结果相同。如果数据存在它可以正常工作但是当数据不存在时我希望它是空白的或者说没有数据存在。


我可以在控制源中使用什么公式来修复这个。任何援助都会非常感激。


谢谢

Hello,

I need help on getting rid of #Error in my fields on a form when no data exist. I was using the below formula:

="" & [System]

and when #Error showed I switched over to

=IIf(IsNull([System])," ",[System])

and that came up with the same results. If data exist it works fine but when data is not there I want it to be blank or say "No data exist".

What formula can I use in the control source to fix this. Any assistance would be most appreciative.

Thanks

推荐答案

究竟是什么[系统]？什么数据类型？


欢迎来到TheScripts！


Linq ; 0）>

What exactly is [System]? What Datatype?

Welcome to TheScripts!

Linq ;0)>

我正在尝试复制此错误以查看是否可以修复它，您的[系统]列是什么数据类型？

I''m trying to duplicate this error to see if I can fix it, what data type is your [System] Column?

我正在尝试复制此错误以查看是否可以修复它，您的[系统]列是什么数据类型？

I''m trying to duplicate this error to see if I can fix it, what data type is your [System] Column?

对于响应缓慢感到抱歉，但有两个是文本，一个是日期/时间。


它看起来像这样


=" of &安培; [学生公司]


="" &安培; [系统]


="在 &安培; [毕业日期]


让我知道你的想法。


谢谢

Sorry about the slow response but two are of text and one is Date/Time.

It looks like this

="of " & [StudentCompany]

="" & [System]

=" on " & [GraduationDate]

Let me know what you come up with.

Thanks

这篇关于摆脱#Error的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！