Quote:
Originally posted by morjaria
None of the two options will work.
Because the function I created is generic, it will take any chart name and there is a table associated with this chart, containing the digitised data. I can't assign aliases because I am selecting all the fields in the table and because it is generic the field names I select will be different, each time I call the function.
I did find a different way of doing the job. I named the fields that should be named with a decimal place within them, all I did was to changed the full stop to a comma and then created a function that if a field name contains a comma then assign this name to a string and replace the comma with a fullstop and use this value.
But I would still like to know how to access a field caption property in a table from code, in ADO.