Listing Field Properties with VBA

Hello again,



Is there a way to gain access to the Field Properties using VBA?

I'm trying to loop thru the Tables in a database and find out the Fields that are indexed in each table.



I can loop through the table Defs to get each table name and a list of Fields but I can't seems to get to the Field Properties, namely "INDEXED".



Thanks in advance for your assistance.

Goh

Listing Field Properties with VBA