Testing to see if a field in an Access table is empty or null 1

[Paladyr]

The following code does not work when the field has nothing in it:

Do Until rstDAO.Fields(2).Value = vbNull

Do Until rstDAO.Fields(2).Value = ""

Do Until Len(rstDAO.Fields(2).Value) < 1

Do Until rstDAO.Fields(2).Value = &quot;Null&quot;
[Code]

How do I properly test to see if the value is Null???  As I step through the code the value comes up as Null but it doesn't pop out of the Do Until statement!  Thanks in advance.

 

[onetomany]

have you tried using the isnull() function


Do Until isnull(rstDAO.Fields(2))

 

[Paladyr]

Sweet.. i'll give that a try!

 

[Paladyr]

That did it, thanks a bunch!!! These forums are rockin today!