[RESOLVED] What the different with this 2 statement ?

[nUflAvOrS]

Hi all,

I got 2 statement, logically it should be same, but the result is different.

Select Case rs.fields(7)
  Case IsNull(rs.fields(7))
      itmx.subitems(7) = ""
  Case Else
      itmx.listsubitems.Add , , "", 1
End Select

If IsNull(rs.fields(7)) Then
    itmx.subitems(7) = ""
Else
    itmx.listsubitems.Add , , "", 1
End If

Actually i need to detect the record if the record in database is null then it would not display a reporticon else it will display the report Icon. By using the if else statement the reporticon display follow record. However, if i used case statement, all the record displaying reporticon regardless the record is null or not !