From: WatsonR@IntelligenCIA.com   
      
   I have used isNull statement for as long as I have used VB..   
      
   Recently I am devugging a program and it is very clear that the "IsNull"   
   function sometimes would return a true even when the value is not Null. Any   
   wild shot or theory as to why this is happening is appreciated. Also, any   
   other alternative is appreciated since I am stuck and cannot proceed without   
   fixing this issue (tried = Null and that doesn't work either).   
      
   Basically, I have a field in a databsse which could be null, so in the code   
   i have:   
      
   ' mfld(x) would have field names like "NAME" etc.   
      
       If IsNull(datPrimaryRS.Recordset(mfld(x))) Then   
          fvalue = ""   
       Else   
          fvalue = datPrimaryRS.Recordset(mfld(x))   
       End If   
      
   I have verified by stepping that isNull is true while moving the cursor   
   shows   
   "Steven Moss" in datPrimaryRS.Recordset(mfld(x))   
      
   What gives?   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)