Hi. I want to see the caption of a field in Access table when a report is extracted to an Excel file. The same problem there is in reports and I have to correct the report's titles each time when I make a report. Generaly, why (Mr Gate!) doesn't the caption property seem anywhere except table's view?
This post is well after the original, but here is a way to do it. You have to use DAO. I couldn't get 'For Each' to work, which may be due to it being DAO. One thing to note is that you will get an error (property not found) if the caption field is not being used, but you can catch that and keep going.