Retrieve caption of a field ??????

[Mendhak]

Hi all,
I want to retrieve the caption property of a field in my MS Access table.
I am using ADO. Tried a lot, couldn't get anything relevant.
Please help.

 

[Allen Browne]

You cannot get this using ADO.
I don't believe ADOX can give it to you either.

You need to use the library that Access itself uses: DAO.
Then it's simply:

CurrentDb().TableDefs("MyTable").Fields("MyField").Properties("Caption")