Hi guys,

How do i detect NULLs in a recordset. forexample:

rst.fields("date").value is actually a null (empty field due to various reasons).

the following simple if else statement cannot do the detection.

if rst.fields("date").value=null then
end sub
else
'carry on with routine
endif

Pls advice.