David Morgan wrote:
I have found that not to be the case Bob. Sometimes can't remember
now but I think I got a Type Mismatch error or something.
Really? I've been using this technique for years and never gotten a Type
Mismatch.
There used to be a kludge in the old VB days of appending an empty string to
the data to counteract the Null possibility, like this:
stNotes = objRs.Fields("Notes").Value & ""
Id sNotes = "" then
But I have not had to use that kludge for years.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"