Error: Microsoft VBScript runtime error '800a005e' Invalid use of Null: 'Replace'
Posted by DMXReady Admin on 17 March 2004 06:42 PM
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'Replace'
This error occurs when you have used a Replace function on your page, for instance, to maintain line breaks from a Memo field, and the particular field your recordset has returned is empty (Null).
You can get around this problem by modifying your code slightly to test the field for a value before the replace code runs.
Add this code to each line where you want the memo field to show line breaks:
myVar = (rsName.Fields.Item("MemoColumn").Value)
If myVar <> "" Then