Welcome to SPN

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

Sign Up Now!

VBA to hide / show LABEL or TEXT box

Discussion in 'Information Technology' started by Martin, Nov 3, 2005.

  1. Martin

    Martin
    Expand Collapse
    Guest

    VBA to hide / show LABEL or TEXT box ? How?

    Thanks!

    Martin
     
  2. Loading...

    Similar Threads Forum Date
    World War 1 To show their contempt for death, some Sikhs had refused to hide in the trenches History of Sikhism May 14, 2014
    Opinion Underneath The Turban: Why Sikhs Do Not Hide Breaking News Aug 23, 2012
    Opinion Underneath the Turban: Why Sikhs Do Not Hide? Breaking News Aug 13, 2012
    UK Hideously diverse Britain: What makes a Sikh join the far right? (Editorial) Breaking News Jun 17, 2010
    Politics Stephen Harper's Canada Chided For Cowardice (Sikh Chic) Breaking News Jun 6, 2010

  3. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "Martin" <lajitong888@21cn.com> wrote in message
    news:u5$iNSE4FHA.476@TK2MSFTNGP15.phx.gbl
    > VBA to hide / show LABEL or TEXT box ? How?


    Set its Visible property. For example,

    ' code running on the form containing the object:
    Me!NameOfControl.Visible = False ' hide it
    Me!NameOfControl.Visible = True ' show it again

    ' code running somewhere else:
    Forms![NameOfForm]!NameOfControl.Visible = False
    Forms![NameOfForm]!NameOfControl.Visible = True

    If a label is attached to text box, hiding the text box will also hide
    the label.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     
  4. Martin

    Martin
    Expand Collapse
    Guest

    Thanks!

    "Dirk Goldgar" <dg@NOdataSPAMgnostics.com> дÈëÏûÏ¢ÐÂÎÅ:%23ESY9ZE4FHA.2640@TK2MSFTNGP09.phx.gbl...
    > "Martin" <lajitong888@21cn.com> wrote in message
    > news:u5$iNSE4FHA.476@TK2MSFTNGP15.phx.gbl
    >> VBA to hide / show LABEL or TEXT box ? How?

    >
    > Set its Visible property. For example,
    >
    > ' code running on the form containing the object:
    > Me!NameOfControl.Visible = False ' hide it
    > Me!NameOfControl.Visible = True ' show it again
    >
    > ' code running somewhere else:
    > Forms![NameOfForm]!NameOfControl.Visible = False
    > Forms![NameOfForm]!NameOfControl.Visible = True
    >
    > If a label is attached to text box, hiding the text box will also hide
    > the label.
    >
    > --
    > Dirk Goldgar, MS Access MVP
    > www.datagnostics.com
    >
    > (please reply to the newsgroup)
    >
    >
     

Share This Page