Checking for Null Values in Text field in VB 5

[Jeev]

Hi

I am working on a Visual Basic 5 project where in I am inserting and updating data in fields of type Text. The database in use is SQL Server. The problem that I am facing is that whenever I check for null values in text fields or even update text fields, I am getting error.

Is there a way to check for null values in text fields using Visual Basic 5. The IsNull function is not working when I check whether the field in the recordset contains null or not.

Any help would be highly appreciated.

Thanks in advance.

[jp140768]

Its been a long time since I used VB5, but does the IS EMPTY function work? NULL is equal to CHR$(0) isn't it - could you compare to that, or use the replace function?

HTH