I have a table in a database on which I have set the caption to a couple of fields. If I create a grid and set that table as the record source the column headers reflect the caption.

If I do something like

SELECT fieldlist FROM myTable etc.

the grid column header becomes the field name rather than the caption.

I expected to find some function that would return the caption somewhere, but I wasn't able to find one.

I know that the caption is stored in the Property field of the DBC and I know how to get to that value. What I haven't figured out is how to parse that field to extract the caption.

So.................

Any information on what function I missed, or how to parse the Property field will be greatly appreciated.

Thanks to all............Rich