Retrieve the Caption property of a field

  • Thread starter Thread starter Adam Goossens
  • Start date Start date
A

Adam Goossens

Hi all,

Does anybody know how I can read the value of the Caption property of a
SQL Server field (as set by Access) at run time?

I need to export some data to Excel (I can't assume it'll always be one
kind of data - I want to be able to pass any SQL string and spit out an
Excel document) and I'm thinking of using the Caption property of the
various fields to store a "user friendly" name, aka "Vendor Name"
instead of "fldVendorName".

Or, if anybody has any alternate suggestions for what I wish to do, I'd
be glad to hear them!

Many thanks,
-Adam.
 
It is unclear to me what you’re trying to do. Are you attempting to return the field names with you query. If so maybe that is more of a SQL question.
 
Back
Top