Get Label Caption

[MikeCDPQ]

I would like to know how I can get a label's caption by clicking on that label.

would be something like

screen.activecontrol but for labels

If I could only get that part I could take it from there to do other stuff.

Thanks

 

[hymn]

surely the caption is displayed in the label
If you go into the properties of the form and click on a caption you will what it is named.
ie caption_label
there are NO events on labels


Hope this helps
Hymn

 

[RoyVidar]

Erm - attached labels have no events, but unattached labels (i e not attached to another control) has some events. But I don't think the Screen.ActiveControl works on a label. I think you'll need to address it by name (or index):

[tt]me("lblMyLabel").Caption[/tt]

Roy-Vidar

 

[hymn]

I apologise I think its time I packed in, my brain cell got stuck on a label of a textbox/control not just the label Goodnight one and all

Hope this helps
Hymn

 

[RoyVidar]

Hey, happen to us all, no need to apologize;-)

Roy-Vidar

 

[MikeCDPQ]

RoyVidar,

That is precisely the point. I don't want to have to refer to it by name. I have about 50 forms with more or less 15 fields each (continuous forms). I would like to be able to click on the label(indeed a detached label with events) and let's say have a msgbox "The label you just clicked on is " & label.caption

Retrieving the caption which is the corresponding control name will allow me to continue with my script.

I tried things with acLabel but nothing works.

Thanks for any suggestion.

Mike

 

[RoyVidar]

You'll need to put some code into each event of each label (unless you're using a function directly in the event property of the label) - what is the difference of using:

[tt]msgbox "the label... " & me("lblMyLabel").caption ' and
msgbox "the label... " & screen.activethingiethatdoesntworkonlabels.caption[/tt]

To get the "functionality" of text controls on labels, convert them to unbound textcontrols, format them as you like... ;-)

Then on the textcontrols use:

[tt]msgbox "the label... " & screen.activecontrol.value[/tt]

Roy-Vidar