See
Re: Memo field not displaying in Thread #
1022989 Message #
1023003e.g.
.columns(x).header1.caption = DBGETPROP("poItems.desc","FIELD","CAPTION")
>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
If it's not broken, fix it until it is.
My Blog