How to show the "fields list button" when the users open the pivot table ?

[Martin]

Up till now, no one of you tops can tell me a method.

It's, when the users open the pivot table, I want the "fields list button"
can be available to them, automatically.

Thanks.

Martin


-------------------------------------------------------------
Because I developed a system, when open, I use the Access settings to hide
all the small buttons.

However, I want the users to be able to use the "field list" button in the
PIVOT VIEW ( acFormPivotTable), so that they can use the "field list" button
to easily create different kinds of PIVOT reports as they like.

I am now badly in need of a VBA sentence to get the "fields list" button
availble to the user.

Martin


-----------------------------------------------------------------

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