主题：判断与添空值

文本框输入问题

对于字符列

Dim a As String
IIF(bh.Text Is Nothing ," " ,a = bh.Text)没问题

但对于

Dim d As Double
IIF(yz.Text Is Nothing," ",d = yz.Text)

和

Dim q As Integer
IIF(nx.Text Is Nothing ," " ,q = nx.Text)

和

Dim o As Date
IIF(rz.Text Is Nothing ," " ,o = rz.Text)

都会报错，为什么

""中间是空字符，但其他的是一个数据类型，所以类型不对，用 is null试下

IIF(yz.Text Is Null ," ",d = yz.Text)不对

IIF(yz.Text Is Null , 0 ,d = yz.Text)也不对啊

 

IIF(yz.Text Is Null , Null ,d = yz.Text)

试下这个

IIF(yz.Text Is Null , 0 ,d = yz.Text)也不对吗？

IIF(yz.Text Is Null,Null,d = yz.Text)不对

IIF(yz.Text Is Null , 0 ,d = yz.Text)也不对，都是编辑通不过

 

上个例子吧

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:管理项目3.table

看下

快下班了，项下，什么问题

这里用IFF不好，直接用代码写

XYT给个明路啊，这样说来说去还是不行啊

我又用了IF 语句也不行