datatype of table field

hi friends

I what to now the type name of a field of a table

Eg rs.fields("name").type

This returns 10 which means it is a string

is their any fuction or some solution so that i can get the typename of the field

I.e "String" instead of 10

rs.fields("name").type returns interger(1,10,8) i want the typename such as "boolean","string","date"

Use the TypeName function on the Value property. I am not sure if this will work in all cases. For example, the database field might be defined as a String but contain Date values. TypeName may return Date and not the expected String. Just test to make sure.

TypeName(rs.fields("name").Value)

sorry to say but ur option does not work !!