Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to see a labels associations if any?

Discussion in 'Information Technology' started by default105, Jul 28, 2006.

  1. default105

    default105
    Expand Collapse
    Guest

    Is there an easy way to see a labels associations with another object, ie
    textbox, combobox?
     
  2. Loading...

    Similar Threads Forum Date
    Akal Takht Jathedar Labels Pal Singh Purewal as an Agent of RSS Hard Talk Feb 20, 2011
    The Prison of One-Word Labels Sikh Sikhi Sikhism Nov 18, 2009

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Programmatically, you can look at its Parent.

    For instance, to find out what control label MyLabel is associated with, you
    can use

    Forms("MyForm").Controls("MyLabel").Parent.Name

    (note that MyForm must be open)

    If the label isn't linked to a control, that will return the name of the
    form.


    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "default105" <default105@discussions.microsoft.com> wrote in message
    news:FBF95C66-A703-4978-BB23-51DA7149FBF5@microsoft.com...
    > Is there an easy way to see a labels associations with another object, ie
    > textbox, combobox?
     
  4. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    When I want to see if a label is "attached", I open the form/report in
    design mode and click on the label. If it is attached, the control to which
    it is attached displays a single "handle" in the upper left corner of the
    control.

    Regards

    Jeff Boyce
    Microsoft Office/Access MVP

    "default105" <default105@discussions.microsoft.com> wrote in message
    news:FBF95C66-A703-4978-BB23-51DA7149FBF5@microsoft.com...
    > Is there an easy way to see a labels associations with another object, ie
    > textbox, combobox?
     
  5. default105

    default105
    Expand Collapse
    Guest

    I know that you can check it that why but what I have noticed by stupidity I
    might add is that if you select a label and use ctrl + x and then ctrl+v to
    paste it in another section, it is still associatied. However just by
    clicking on it, it does not show the handle on the control it is associated
    with.

    "Jeff Boyce" wrote:

    > When I want to see if a label is "attached", I open the form/report in
    > design mode and click on the label. If it is attached, the control to which
    > it is attached displays a single "handle" in the upper left corner of the
    > control.
    >
    > Regards
    >
    > Jeff Boyce
    > Microsoft Office/Access MVP
    >
    > "default105" <default105@discussions.microsoft.com> wrote in message
    > news:FBF95C66-A703-4978-BB23-51DA7149FBF5@microsoft.com...
    > > Is there an easy way to see a labels associations with another object, ie
    > > textbox, combobox?

    >
    >
    >
     
  6. default105

    default105
    Expand Collapse
    Guest

    Do you mean doing this in the immediate window?

    "Douglas J Steele" wrote:

    > Programmatically, you can look at its Parent.
    >
    > For instance, to find out what control label MyLabel is associated with, you
    > can use
    >
    > Forms("MyForm").Controls("MyLabel").Parent.Name
    >
    > (note that MyForm must be open)
    >
    > If the label isn't linked to a control, that will return the name of the
    > form.
    >
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "default105" <default105@discussions.microsoft.com> wrote in message
    > news:FBF95C66-A703-4978-BB23-51DA7149FBF5@microsoft.com...
    > > Is there an easy way to see a labels associations with another object, ie
    > > textbox, combobox?

    >
    >
    >
     
  7. default105

    default105
    Expand Collapse
    Guest

    Nevermind I see it does work in the immediate window, is there a way to
    unassocitate it or do you have to delete it and create a new label, I am
    working with mouseover effects and I know the will not work properly if they
    are associated.

    "Douglas J Steele" wrote:

    > Programmatically, you can look at its Parent.
    >
    > For instance, to find out what control label MyLabel is associated with, you
    > can use
    >
    > Forms("MyForm").Controls("MyLabel").Parent.Name
    >
    > (note that MyForm must be open)
    >
    > If the label isn't linked to a control, that will return the name of the
    > form.
    >
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "default105" <default105@discussions.microsoft.com> wrote in message
    > news:FBF95C66-A703-4978-BB23-51DA7149FBF5@microsoft.com...
    > > Is there an easy way to see a labels associations with another object, ie
    > > textbox, combobox?

    >
    >
    >
     
  8. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Cut and paste should work to disassociate.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "default105" <default105@discussions.microsoft.com> wrote in message
    news:7C65C760-A536-4354-98D2-E7CEF56FA45B@microsoft.com...
    > Nevermind I see it does work in the immediate window, is there a way to
    > unassocitate it or do you have to delete it and create a new label, I am
    > working with mouseover effects and I know the will not work properly if

    they
    > are associated.
    >
    > "Douglas J Steele" wrote:
    >
    > > Programmatically, you can look at its Parent.
    > >
    > > For instance, to find out what control label MyLabel is associated with,

    you
    > > can use
    > >
    > > Forms("MyForm").Controls("MyLabel").Parent.Name
    > >
    > > (note that MyForm must be open)
    > >
    > > If the label isn't linked to a control, that will return the name of the
    > > form.
    > >
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "default105" <default105@discussions.microsoft.com> wrote in message
    > > news:FBF95C66-A703-4978-BB23-51DA7149FBF5@microsoft.com...
    > > > Is there an easy way to see a labels associations with another object,

    ie
    > > > textbox, combobox?

    > >
    > >
    > >
     
  9. Jeff Conrad

    Jeff Conrad
    Expand Collapse
    Guest

    Hold down the CTRL key while you single click on
    each of the Switchboard form's labels. This will highlight
    them all. Then Cut and then Paste back on to the form.

    They will disassociate this way, but you can move the
    whole group back into position together quite easily
    since they are highlighted together.

    --
    Jeff Conrad
    Access Junkie - MVP
    http://home.bendbroadband.com/conradsystems/accessjunkie.html
    http://www.access.qbuilt.com/html/articles.html

    "default105" wrote in message:
    news:7C65C760-A536-4354-98D2-E7CEF56FA45B@microsoft.com...

    > Nevermind I see it does work in the immediate window, is there a way to
    > unassocitate it or do you have to delete it and create a new label, I am
    > working with mouseover effects and I know the will not work properly if they
    > are associated.
     
  10. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    I don't know why it isn't working for you. When I click on a label control,
    if it is attached to another control, that other control's upper left handle
    is displayed. If the label control isn't attached, nothing (else) is shown.

    Why are you trying to learn to which control a label is attached? Knowing
    this might help offer other approaches to solving what you are trying to do.

    Regards

    Jeff Boyce
    Microsoft Office/Access MVP

    "default105" <default105@discussions.microsoft.com> wrote in message
    news:D3C47B84-FE76-4F6C-AA9B-99617D4B2C61@microsoft.com...
    >I know that you can check it that why but what I have noticed by stupidity
    >I
    > might add is that if you select a label and use ctrl + x and then ctrl+v
    > to
    > paste it in another section, it is still associatied. However just by
    > clicking on it, it does not show the handle on the control it is
    > associated
    > with.
    >
    > "Jeff Boyce" wrote:
    >
    >> When I want to see if a label is "attached", I open the form/report in
    >> design mode and click on the label. If it is attached, the control to
    >> which
    >> it is attached displays a single "handle" in the upper left corner of the
    >> control.
    >>
    >> Regards
    >>
    >> Jeff Boyce
    >> Microsoft Office/Access MVP
    >>
    >> "default105" <default105@discussions.microsoft.com> wrote in message
    >> news:FBF95C66-A703-4978-BB23-51DA7149FBF5@microsoft.com...
    >> > Is there an easy way to see a labels associations with another object,
    >> > ie
    >> > textbox, combobox?

    >>
    >>
    >>
     
  11. default105

    default105
    Expand Collapse
    Guest

    I don't know either, because usually what you guys say is golden. Why was I
    trying to find the control, because when I would cut the label and paste it,
    it did not act as it was associated by clicking on it, using D Steele's
    method in the immediate window showed the association was removed but if I
    would add a mouse over event to change forecolor, backcolor, etc. It would
    not work. Not even if I would compile, compact and repair, quit and
    relaunch, decomile, nothing, the event would not work, but if I would create
    new label, set all the properties the same as before but not associated to
    anything, the mouseover event would work. That is why I was looking to see
    if it was associated with anything.

    Does that help?

    "Jeff Boyce" wrote:

    > I don't know why it isn't working for you. When I click on a label control,
    > if it is attached to another control, that other control's upper left handle
    > is displayed. If the label control isn't attached, nothing (else) is shown.
    >
    > Why are you trying to learn to which control a label is attached? Knowing
    > this might help offer other approaches to solving what you are trying to do.
    >
    > Regards
    >
    > Jeff Boyce
    > Microsoft Office/Access MVP
     
  12. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    So, you want to know if a label is attached so you can detach it and
    reattach it?

    When a form starts "misbehaving" I've been known to set it aside and try
    creating a new form. I have no absolute proof, but it seems to me that a
    form or a report might get a chicken bone stuck and not be able to tell me
    there's something wrong. Starting over and re-creating the form/report
    seems to "fix" whatever it was.

    Good luck!

    Jeff Boyce
    Microsoft Office/Access MVP

    "default105" <default105@discussions.microsoft.com> wrote in message
    news:5A8A0FAE-DC6C-4361-9848-4FA047D7A2C7@microsoft.com...
    >I don't know either, because usually what you guys say is golden. Why was
    >I
    > trying to find the control, because when I would cut the label and paste
    > it,
    > it did not act as it was associated by clicking on it, using D Steele's
    > method in the immediate window showed the association was removed but if I
    > would add a mouse over event to change forecolor, backcolor, etc. It
    > would
    > not work. Not even if I would compile, compact and repair, quit and
    > relaunch, decomile, nothing, the event would not work, but if I would
    > create
    > new label, set all the properties the same as before but not associated to
    > anything, the mouseover event would work. That is why I was looking to
    > see
    > if it was associated with anything.
    >
    > Does that help?
    >
    > "Jeff Boyce" wrote:
    >
    >> I don't know why it isn't working for you. When I click on a label
    >> control,
    >> if it is attached to another control, that other control's upper left
    >> handle
    >> is displayed. If the label control isn't attached, nothing (else) is
    >> shown.
    >>
    >> Why are you trying to learn to which control a label is attached?
    >> Knowing
    >> this might help offer other approaches to solving what you are trying to
    >> do.
    >>
    >> Regards
    >>
    >> Jeff Boyce
    >> Microsoft Office/Access MVP

    >
     

Share This Page