Empty Cell Bug

You showed how to fix this bug with an array, but how do you fix this with a recordset containing emty cells or fields?

which version?
If it's version 1 and you are using the dynamic example, the code Alex used was:

function activewidgets_html(s)

s = Replace(s, "\", "\\")
s = Replace(s, """", "\""")
s = Replace(s, vbCr, "\r")
s = Replace(s, vbLf, "\n")

activewidgets_html = s
end function


I made a small change like so:

function activewidgets_html(s)
If Not isNull(s) Then
s = Replace(s, "\", "\\")
s = Replace(s, """", "\""")
s = Replace(s, vbCr, "\r")
s = Replace(s, vbLf, "\n")
End If
activewidgets_html = s
end function


We were getting an error on the replace function when it was applied against an null value.

which version?
If it's version 1 and you are using the dynamic example, the code Alex used was:

function activewidgets_html(s)

s = Replace(s, "\", "\\")
s = Replace(s, """", "\""")
s = Replace(s, vbCr, "\r")
s = Replace(s, vbLf, "\n")

activewidgets_html = s
end function


I made a small change like so:

function activewidgets_html(s)
If Not isNull(s) Then
s = Replace(s, "\", "\\")
s = Replace(s, """", "\""")
s = Replace(s, vbCr, "\r")
s = Replace(s, vbLf, "\n")
End If
activewidgets_html = s
end function


We were getting an error on the replace function when it was applied against an null value.

It works.

Thanks for your help Jim.