Label associated with text/combo box in Access 2000

R

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!
 
L

Linq Adams via AccessMonster.com

I think you've already stated the only options you have; there's no way to
"asscoiate" a newly created label to an existing textbox/combobox that I know
of in any version prior to v2007.
 
F

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!
Click to expand...

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.
 
L

Linq Adams via AccessMonster.com

It's nice to know that you can attach a label to a control, and actually that
solves the OPs problem, because.

"However, in Form Datasheet view, the labels of controls are ignored."

is incorrect. If there is an attached label, it is used for the column header.
The control name is only used as a header if there is no attached label.
 
Top