[b] Passing Caption property using ADO [/b]

[Jimdeb03]

I'm looking for a method to pass the Caption property from an Access database using ADO 2.7 to my VB application. The field names are rather cryptic which are used to populate DataGrid columns and labels throughout the app.

It would be nice if instead the field name was displayed to show the Caption instead.

All queries are in the app so implementing aliases for each field for each query is something I'd rather avoid.

Any ideas?
thanks
Jim

 

[RoyVidar]

Hi!

Not sure if the Caption property is exposed thru ADO/ADOX, but if you could use the Description property, there's some samples on how to retrieve that in this thread thread709-752030. Else, you might try the question in that forum or the VB5/6 forum (forum222), since you're trying this from VB.

DAO offer means of retrieving the caption, see for instance, thread705-764083 and thread707-748373, note that these samples are from within Access.

Roy-Vidar