A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Forms keep their size when reports are maximized?



 
 
Thread Tools Display Modes
  #1  
Old August 19th, 2009, 07:24 PM posted to microsoft.public.access.forms
Erin
external usenet poster
 
Posts: 164
Default Forms keep their size when reports are maximized?

I have a database with lots of forms and reports. Most of my forms are small
and do not take up the whole screen. When a user runs a report and maximizes
it in order to read it, all the forms are now maximized, too. Is there any
way to set it so that the forms stay their smaller size when a report is
maximized? Or, is there a way to maximize the reports on open but keep the
forms their smaller size??

Thanks!!!!!!
  #2  
Old August 19th, 2009, 09:30 PM posted to microsoft.public.access.forms
M Skabialka
external usenet poster
 
Posts: 570
Default Forms keep their size when reports are maximized?

In the On Close event on the reports
=DoCmd.Restore
And if they always maximize them:
In the On Open event:
=DoCmd.Maximize

"Erin" wrote in message
...
I have a database with lots of forms and reports. Most of my forms are
small
and do not take up the whole screen. When a user runs a report and
maximizes
it in order to read it, all the forms are now maximized, too. Is there any
way to set it so that the forms stay their smaller size when a report is
maximized? Or, is there a way to maximize the reports on open but keep the
forms their smaller size??

Thanks!!!!!!



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.