Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / July 2007

Tip: Looking for answers? Try searching our database.

Print Preview Window Handling

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bob Howard - 31 Jul 2007 00:16 GMT
Hi,

I open a report from VBA code in a form.  I use acViewPreview and open it as
a dialog (window type is acDialog).

In the report's OnOpen event, I maximize.

The reason I want that is because I want a full screen preview, and I don't
want any of the typical Access menubar or toolbars.

So all this is working fine.

Problem:  If the user double-clicks the print preview's window title bar (at
the very top of the screen), this causes a "window restore" action to be
taken.  But it's not reversible!

I have controlbox=yes and closebutton=yes.  I have minmaxbuttons=bothenabled
... but the window has no min or max or restore buttons showing.

So once I double-click ( ===> restore) I cannot maximize it again.

Any clues??

This is Access 2003.

Bob
Damian S - 31 Jul 2007 03:30 GMT
How about having the docmd.maximize in the on activate event, and perhaps to
be really sure, in the on resize event?

Damian.

> Hi,
>
[quoted text clipped - 22 lines]
>
> Bob
Bob Howard - 31 Jul 2007 05:29 GMT
I'll try the activate.  There is no resize event for a report, however.
Bob.

> How about having the docmd.maximize in the on activate event, and perhaps
> to
[quoted text clipped - 32 lines]
>>
>> Bob
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.