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

M

Martin

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!
 
V

Van T. Dinh

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???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting Radio Buttons to work, that are inserted via AutoText 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Form hides control buttons 0
ASK Field Formatting 1
Listbox and command button don't appear in form view 1
access97 to 2002 search button conversion error 2
How to show the "fields list button" when the users open the pivot table ? 0
Make table query only runs from design view. 3

Top