Getting the Datatypes of your Fields

[admin]

The following will return the data type of your fields...

RS.Fields(icounter).Type

RS is the RecordSet and icounter is the ordinal number.