Retrieve caption of a field ??????

M

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.
 
A

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")
 
Top