Welcome to SPN

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

Sign Up Now!

How to show the "fields list button" again, by VBA ?

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

  1. Martin

    Martin
    Expand Collapse
    Guest

    At first, I use VBA to hide all the bars and small buttons.

    I am now want to show the "fields list button" ( I don't know exactly the
    English is ) when I open a FORM at the FORM'S opening event.

    Please tell me what should the VBA is?

    I have tried, by failed. Application.CommandBars("Form/View
    Design").Controls(1).Visible = True
    also, I am not sure wheater the "fields list samll button" is
    CommandBars("Form/View Design").Controls(1)


    Thank you very much!
     
  2. Loading...


  3. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    There is, indeed, a "Field List" button in the "Form Design" Toolbar (and
    the Menu View / Field List) but this is only available (appropriately so) in
    the *DesignView* of the Form.

    Why would you want the "Field List" button available in the opening of the
    NormalView (operating view) of the Form???

    --
    HTH
    Van T. Dinh
    MVP (Access)



    "Martin" <lajitong888@21cn.com> wrote in message
    news:er14Op06FHA.3048@TK2MSFTNGP10.phx.gbl...
    > At first, I use VBA to hide all the bars and small buttons.
    >
    > I am now want to show the "fields list button" ( I don't know exactly the
    > English is ) when I open a FORM at the FORM'S opening event.
    >
    > Please tell me what should the VBA is?
    >
    > I have tried, by failed. Application.CommandBars("Form/View
    > Design").Controls(1).Visible = True
    > also, I am not sure wheater the "fields list samll button" is
    > CommandBars("Form/View Design").Controls(1)
    >
    >
    > Thank you very much!
    >
    >
     

Share This Page