Null Values

[sseigler]

I have a text field that I am tying values to based on a SQL string. This works great, until the recordset tries to supply a null value to to the text field's value. I have tried using an if statement to test for the null value, but I'm having trouble testing. Here's a sample of the code...

If rstMonitor.Fields("Speed").Value = Null Then
BaseWindow.navigate "HelpDesk_MonitorConfirm.html"
Else
hfldSpeed.Value = rstMonitor.Fields("Speed").Value
End If

What is the proper syntax to test the field for a null value?

TIA
Stephen

try:

If IsNull(rstMonitor("Speed")) Then
  BaseWindow.Navigate "HelpDesk_MonitorConfirm.html"
Else
  hfldSpeed.Value = rstMonitor("Speed")
End If

[Glenn]

Use the ISNull function

[sseigler]

Thanks, these answers get me going!