isNull，明明搜索果是空，返回值是false

 Sql = "select distinct op_dept from GLB_OPE_FINAL2 where op_model = '" + model + "'"
        rs1.Open Sql, mycon
        If Not IsNull(rs1.Fields(0)) Then
            dept = CStr(rs1.Fields(0))//有果了if
        End If
        rs1.Close

[解决办法]
len(XXX)<1
先看看 len(XXX)=多少,再上面写上len(XXX) < Y
[解决办法]
If Not IsNull(rs1.Fields(0)) Then 改为
rs1.Fields.Count > 0

我感到出问题的不是进入IF,而且
IsNull(rs1.Fields(0))
出了问题

[解决办法]
应该是：eof或bof才对