Toggling toolbar visibility

[Geert Vancompernolle]

Hi,

Is there a possibility to toggle the appearance of all the toolbars to
switch them on/off?

Reason of asking: when printing out the 'current view', it's always
interesting to have as much as possible screen area available, so that your
current view can be made as big as possible, not limited by the (sometimes
big) amount of toolbars residing on the screen.

Simply being able to remove and restore them would be a nice feature.

-- Geert

 

[Hin]

In VBA:

' Hide toolbar and menus
Application.ShowToolbar = False
' Hide status bar
Application.ShowStatusBar = False

or

' toggle full screen mode
Application.DoCmd visCmdFullScreenMode

 

[Geert Vancompernolle]

In VBA:

' Hide toolbar and menus
Application.ShowToolbar = False
' Hide status bar
Application.ShowStatusBar = False

or

' toggle full screen mode
Application.DoCmd visCmdFullScreenMode

Hin,

Thanks for this useful information.
Allow me to ask one more question: I'm new in the VBA world and I would
like to know how to connect such scripts to buttons on the toolbars.
Could you explain me?
Or could you give me links to websites explaining this?

Thanks in advance,

-- Geert

 

[Hin]

You can make use of the AddOnName property of the MenuItem/ToolbarItem.
Setting a value of moduleName.procName(arguments) will "connect" the menu
item or toolbar button to the VBA procedure.

For details, u may take a look at the AddOnName property in developer
reference.