R
Rob Parker
I am experiencing the same (or very similar) problem as another user posted
a couple of weeks ago in a thread "Report is maximizing weird" - see
http://groups.google.com.au/group/m...1/a37cf67468fb6232?lnk=st&q=#a37cf67468fb6232
I have several reports in a database (running in Access 2002 under Win XP
Pro, with all service packs; database in Access 2000 file format). All
these reports have the following code:
Private Sub Report_Activate()
DoCmd.Maximize
End Sub
Private Sub Report_Deactivate()
DoCmd.Restore
End Sub
Some reports open maximized correctly, while others do not; they open in a
window, which is as wide as the application window and taller than the
application window. This window cannot be moved or resized. It has both
horizontal and vertical scrollbars, but the horizontal scrollbar (which
includes the page navigation buttons) is not a real scroll-bar - it moves
with the report text if the vertical scrollbar is used, and disappears when
clicked on (in either the navigation area or the scrollbar).
The problem appears to also be related to the window size of the Access
application. I normally run Access maximized, and when I do so the problem
appears consistently for some reports - but not, as I said earlier, for all
reports. However, if I reduce the size of the Access application window,
the maximize behaviour of a report which always exhibits the problem
behaviour in a maximized Access window changes; when the Access application
window becomes small enough to require a horizontal scrollbar to display the
database window, the reports will maximize correctly. By reducing the size
of the database window, I can get the problem reports to exhibit the strange
behaviour in an Access application window only a couple of hundred pixels
wide.
A little further playing shows that if I force a horizontal scrollbar to
appear for the Access application window - by moving the database window
partially off-screen - then all reports will maximize correctly.
Apart from the post a couple of weeks ago, has anybody else seen this
behaviour? More importantly, does anyone know what it's caused by and how
to resolve it? [Note: I don't consider "position the database window
partially off-screen" to be an acceptable solution to the problem ;-) ]
TIA,
Rob
a couple of weeks ago in a thread "Report is maximizing weird" - see
http://groups.google.com.au/group/m...1/a37cf67468fb6232?lnk=st&q=#a37cf67468fb6232
I have several reports in a database (running in Access 2002 under Win XP
Pro, with all service packs; database in Access 2000 file format). All
these reports have the following code:
Private Sub Report_Activate()
DoCmd.Maximize
End Sub
Private Sub Report_Deactivate()
DoCmd.Restore
End Sub
Some reports open maximized correctly, while others do not; they open in a
window, which is as wide as the application window and taller than the
application window. This window cannot be moved or resized. It has both
horizontal and vertical scrollbars, but the horizontal scrollbar (which
includes the page navigation buttons) is not a real scroll-bar - it moves
with the report text if the vertical scrollbar is used, and disappears when
clicked on (in either the navigation area or the scrollbar).
The problem appears to also be related to the window size of the Access
application. I normally run Access maximized, and when I do so the problem
appears consistently for some reports - but not, as I said earlier, for all
reports. However, if I reduce the size of the Access application window,
the maximize behaviour of a report which always exhibits the problem
behaviour in a maximized Access window changes; when the Access application
window becomes small enough to require a horizontal scrollbar to display the
database window, the reports will maximize correctly. By reducing the size
of the database window, I can get the problem reports to exhibit the strange
behaviour in an Access application window only a couple of hundred pixels
wide.
A little further playing shows that if I force a horizontal scrollbar to
appear for the Access application window - by moving the database window
partially off-screen - then all reports will maximize correctly.
Apart from the post a couple of weeks ago, has anybody else seen this
behaviour? More importantly, does anyone know what it's caused by and how
to resolve it? [Note: I don't consider "position the database window
partially off-screen" to be an acceptable solution to the problem ;-) ]
TIA,
Rob