Empty rows in a recordset

[richardn]

I opened a ADODB recordset from a query that I built from a table.
i want to check if there is some empty cells in my recordset :
if rst![MyField] Is NULL then...
doesn't work, Itryed using the value property(this is the default, it doesn't matter) , I checked with "", not works any way, I am interested to know when a cell is empty.
Thanks,
Richard

 

[SteveA]

Try

If IsNull(rst![MyField]) Then ...

Cheers,
SteveA

[This message has been edited by SteveA (edited 01-27-2002).]

 

[richardn]

thanks