rename control in the subform

[pooterpooter]

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 ?

 

[Sashanan2]

Even with the subform being in datasheet format normally, can't you just open it in design mode, rightclick the field and change its Name property while leaving its Control Source and the Caption of its associated label the same?


"Any fool can defend his or her mistakes; and most fools do." -- Dale Carnegie