No - it doesn't make a difference. I had already tried it with ".Value" and
with no qualifier - same result.

However, your suggestion made me look at it again. I set a watch on the
target cell with Sheets("Sheet2").Range("R27") notation and then looked thru
the properties of the cell - maybe I missed something, but there is NO
".Value" property on a cell!!!??? There is a ".Value2" so I tried ...
..Cells(r, c + f).Value2= rs.Fields(f).Value and this works perfectly for all
target cells of all data types.

So, I guess in one respect the problem is solved ... but in another respect,
does Microsoft have something to explain about the inconsistent result
achieved using ... .Cells(r, c + f).Value= rs.Fields(f).Value

Thanks for your interest.
---------------------------------------------------------------------------------
"Smallweed" wrote:

Strange - does ... .Cells(r, c + f).Value= rs.Fields(f).Value make any
difference?