Hello,
I have renamed my columns by using the caption property in the table design view. I now would like to use this table as the source for a sub form and see the columns named as I set in the caption. This works when the form is displayed as a single form or continuous form. But if I use the display form in spreadsheet view option it reverts back to the column names and ignores the captions.
What I would like to know is if this is supposed to happen and if there is a way around this, because I would like to keep my column names in the table as they are and use the captions I defined on the form in spreadsheet view.
If anybody has got any ideas I would be very grateful.