Determining Data Types

[Nancy]

In my VBA/Access Application, I am trying to get rid of
null values in a recordset I have just created. What I
would like to do is loop through the recordset and set
the values to "", 0, 12:00:00 AM, depending on whether
the data type of the field is text, currency, or date. I
could do it the long way and go through each field in the
recordset, but I would like to know if there is an easier
way in which I can determine datatype and then go from
there.

Thanks!