Field Description

Hi all,

When we create a table in MS Access, we input 3 entries:

1) Field Name;
2) Field Type and
3) Field Description

Is there any way through which I can fetch that Field Description value programatically?

Something like 'rs.Fields(Index).Description' :rolleyes:

Pls guide

Regards,

Prakash

if you use a datareader you can use the properties

*GetDataTypeName
*GetFieldName

for each row to get it's system and db types

for datasets, the only way I can think of is to make a typed dataset based on the xls file of the database??

Anyone else?


yours
Henrik

got the answer from db section

VB Code:

rs.Fields("FieldName").Properties("Description").Value

regards

prakash