表达式列:iif(第一列 is null, 0, 1) + iif(第二列 is null, 0, 1) + iif(第三列 is null, 0, 1)
代码:datacolchanged事件
Select case e.datacol.name
case "第一列","第二列","第三列"
e.datarow("数量") = iif(e.datarow("第一列") = nothing, 0, 1) + iif(e.datarow("第二列") = nothing, 0, 1) + iif(e.datarow("第三列") = nothing, 0, 1)
End Select