3.2.0

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?
John Souv
October 12,
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.
Jim
October 13,
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.
Jim
October 13,
It works.

Thanks for your help Jim.
John Souv
October 14,

This topic is archived.

See also:


Back to support forum