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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appending a "Caption" Property to Fields in a recordset 8
How to get the "Caption" value for a field in a table. 5
Caption Property of a Field 1
DoCmd.TransferText does not export field names correctly 1
vertical orientation caption in a label 3
Word 2007- Insert figure caption 2
Access Property sheet data missing also syntax 0
reporting showing field caption from field list box records 3

Top