Enabling the "Print Preview" ToolBar !

[Prakash Wadhwani]

Under Tools->Startup I have set AllowBuiltInToolbars to NO.

Thus in the Print Preview Window, the user cannot CLOSE the window or
even Print.

In my Report's on Open Event I place the foll code:

DoCmd.ShowToolbar "Print Preview", acToolbarYes
However the ToolBar is not visible ... according to Access-Help:
***
The built-in toolbars are also not available to display or hide by
using this action if you set the AllowBuiltInToolbars property to
False (0) in Visual Basic, or if you set the Allow Built-in Toolbars
option to False in Visual Basic by using the SetOption method.
****

So what are my options now ? Will I have to manually switch off each
Toolbar using VBA at start-Up ? If so can anyone please post a
complete list of ALL toolbars to ensure I don't miss any ?

Or ... is there any easier way ??

Thx & Best Rgds,
Prakash.

[Rick Brandt]

"Prakash Wadhwani" <si****@omantel.net.om> wrote in message
news:60**************************@posting.google.c om...

Under Tools->Startup I have set AllowBuiltInToolbars to NO.

Thus in the Print Preview Window, the user cannot CLOSE the window or
even Print.

In my Report's on Open Event I place the foll code:

DoCmd.ShowToolbar "Print Preview", acToolbarYes
However the ToolBar is not visible ... according to Access-Help:
***
The built-in toolbars are also not available to display or hide by
using this action if you set the AllowBuiltInToolbars property to
False (0) in Visual Basic, or if you set the Allow Built-in Toolbars
option to False in Visual Basic by using the SetOption method.
****

So what are my options now ? Will I have to manually switch off each
Toolbar using VBA at start-Up ? If so can anyone please post a
complete list of ALL toolbars to ensure I don't miss any ?

Or ... is there any easier way ??

AllowBuiltInToolbars = No only disallows *built in* toolbars. So the solution
is to build your own toolbar with the print options you want on it and display
that instead. The easiest way is to put the name of your custom toolbar in the
Toolbar property of the report.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com