Weird replace error (SOLVED)

[ShotokanTuning]

I have a Access database with field type=Memo.

When I show this field in the browser I use this:

<%
descr = rsVisitReport("Address")
descr = replace(descr, vbCrlf, "<BR>")
Response.Write descr
%>
This works fine with fields that contain data but it returns an error when the Address field is empty.

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'replace'

/system/Page.asp, line (number)



So I tried this little code:
<%
if (not rsVisitReport("Address")="") then
descr = rsVisitReport("Address")
descr = replace(descr, vbCrlf, "<BR>")
Response.Write descr
end if
%>
This fixes the old problem and empty fileds are shown correctly but when the field isn't empty and the replace takes place, now give the error:

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'replace'

/system/Page.asp, line (number)



I don't get it.

[Ecniv]

Nulls - always crap.

Couple of ways to fix:

1) strData = rst("field") & ""
2) strData = nnz(rst("field"),"") - where nnz is a function to replace the nnull value with a default value
3) If not (Isnull(rst("field"))) then 'do code to process/replace


Vince

[ShotokanTuning]

Method 3 is the same as I used. Also same result.

Method 1 works perfectly.

Thanks again.