Label associated with text/combo box in Access 2000

[Rod Behr]

Sadly, I am forced to use Access 2000, so my question applies to this version.

Having deleted the label which is associated with a text/combo box, how do I
restore it without deleting the text/combo box and re-inserting it? Or, put
another way, the form is to be viewed in datasheet view - how do I change the
column heading for the field in Datasheet view without changing the name of
the form field?

Thanks!

 

[fredg]

Sadly, I am forced to use Access 2000, so my question applies to this version.

Having deleted the label which is associated with a text/combo box, how do I
restore it without deleting the text/combo box and re-inserting it? Or, put
another way, the form is to be viewed in datasheet view - how do I change the
column heading for the field in Datasheet view without changing the name of
the form field?

Thanks!

So you really only want to change the column header text?

In Form Single View or Form Continuous view you can attach a label to
a control by first adding an unbound label to the form, then cutting
it, then selecting the text box/combo box and pasting. The new label
will then be 'attached' to the text/combo control. Moving one will
also move the other.

However, in Form Datasheet view, the labels of controls are ignored.
If you wish to change the column header text, simply change the NAME
of the combo box itself (not the name of the bound field). Then follow
through and change any code that refers to the old combo box name.