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

Try

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

Cheers,
SteveA http://www.access-programmers.co.uk/ubb/smile.gif

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

thanks