Enumating fields in a table

[BigHughie]

I should know the answer to this - but I can't seem to get it to work.

I need to copy the text from the table design view description property into the caption for each field name in each table in the database.

So I need to loop thru the tables (easy) then loop thru the fields collection for each table then set the caption to be equal to the description so that when i do the auto creation of my forms I get the correct labels. I could do it manually but this is a BIG system

Can anyone help please ( I'm using Acc 2k file format in Access XP (very slow))

Thanks
Hugh

 

[BigHughie]

I can't spell Enumerating.

Having inspected the object browser, it doesn't look like I can do it with DAO or ADOX But surely the description for the field is held somewhere? as is the caption? Is it in the properties? Am I being stupid

Help