Control Label

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

How do you reference the caption of the label attached to a control on a form by
first referencing the form?

For example, textbox named Addr1 has an attached label with the caption
"Address1". What is the expression to get a Msgbox to display "Address1" ?

Something like:

MsgBox Me!Addr1.AttachedLabel.Caption

Thanks!

Mark
 
The attached label is the first member of the Controls collection:

MsgBox Me!Addr1.Controls(0).Caption
 
Allen,

Thank you very much!!

What else is in the controls collection of a control? Can you point me to
something in Help on this?

Mark
 
Hi Mark. This collection is kind of an oddity for text boxes, as they can't
have anything but an attached label. It's probably there in help somewhere,
but you have to stumble across it - usually by asking questions in the
newsgroups. :-)

The option buttons in an option group are part of its Controls collection.

Tab control pages have a Controls collection - and each control has a
TabIndex within that collection.

Forms and reports have lots of members in their Controls collection, and
their sections (e.g. Detail) also have a Controls collection.

To go the opposite direction, ask for the Parent of the control.

If you are ever working in Access 1 or 2, things don't work like that.
 
Thanks, Allen! I appreciate the help.

Mark


Allen Browne said:
Hi Mark. This collection is kind of an oddity for text boxes, as they can't
have anything but an attached label. It's probably there in help somewhere,
but you have to stumble across it - usually by asking questions in the
newsgroups. :-)

The option buttons in an option group are part of its Controls collection.

Tab control pages have a Controls collection - and each control has a
TabIndex within that collection.

Forms and reports have lots of members in their Controls collection, and
their sections (e.g. Detail) also have a Controls collection.

To go the opposite direction, ask for the Parent of the control.

If you are ever working in Access 1 or 2, things don't work like that.
Click to expand...
 
This SHOULD work:

Forms![NameOfControlLabel].Caption

Don't reference the control, just its label.
 
Back
Top