Receiving a Null Value in a recordset

[mjonesa1]

I have a recordset that is returning a null value.

"strEvan = rstEVAN![F8]"

I would like to use a Message box to tell the user to select an alternative filter due to the null value.

How do I code for this?

 

[Micron]

Dim strMsg as String 'goes in declarations section

If IsNull(strEvan) or strEvan = "" then
  strMsg = "No records exist for the chosen filter." & vbCrLf
  strMsg = strMsg & "Please select a different filter."
  msgbox strMsg 'set your message box title and button options here as well
  Exit Sub 'or function?
End If

Would it make more sense to convert the Null via Nz function?