The only solution that I've found is to utilize the isnull(fldname,'') function to make sure that the result recordset has no null values.

I've also seen this when converting recordsets to...