Control Label

[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

 

[Allen Browne]

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

MsgBox Me!Addr1.Controls(0).Caption

 

[Mark]

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

 

[Allen Browne]

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.

 

[Mark]

Thanks, Allen! I appreciate the help.

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.

 

[DanK]

This SHOULD work:

Forms![NameOfControlLabel].Caption

Don't reference the control, just its label.