In my subform i have controls which i want to rename but i
do not want to change the real names of the fields in the
tables,nor add the name to the Caption in the field of the
table.Is it possible ?
For example, in the table [Order details] i have a field called Quantity.I want to rename it to Pieces.I want to do it in the subform,and not in the table itself, where i might have written the word Pieces in the field Caption.I have tried to rename the field from the main form but i did not succeed. The problem is that the subfom is in a datasheet format and i cannot just rename the control.Is it impossible to do so ?