Startup Form Size

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I am using a form of my own design as the Startup form. I
would like for the form always to be maximized, so that
other forms open in front of it. As it is now, whenever I
click on a command button on the startup form to open
another form, the startup form shrinks. I can make it
maximize whenever it is on top, but not when another form
si in front of it. DoCmd.Maximize does not do the trick,
no matter to which event I attach it. I have searched
newsgroups, and have almost come to the conclusion that
this seemingly simple wish is either impossible to meet or
else is so complex that it is not worth doing.
 
Try just placing the docmd.maximize command in the OnOpen
event of your main form. Then set the Popup and Modal
properties of the second form to Yes. Then try opening
the first form. It should maximize. Then open the second
form and it should open in front of the first form and
not cause the first form to get smaller.

HTH

Byron
 
If you don't want to use Forms in Dialog mode, you can try
the code from the Access Web:

<http://www.mvps.org/access/api/api0022.htm>

to maximize the Startup Form (but it is still
in "Restored" state as far as Windows concerns). This
way, it won't be restored when other Forms are opened
in "Restored" state.

HTH
Van T. Dinh
MVP (Access)
 
Thanks for the reply and for the link. If I understand
what you mean by using the form in dialog mode (i.e. as a
dialog box, with pop-up and modal set to yes), it does not
do what I need. Here is the situation: I have a main
form functioning as the switchboard, with a number of
command buttons that open other forms. The reason dialog
mode does not work for me is that I need to do other
things at those second tier forms (the ones I open from
the switchboard), such as preview a report. This does not
seem to be possible, as the form retains the focus and the
report never comes to the top. I can open other forms
from the second tier form, but I cannot preview a report.
Regarding the link, I do not understand a single line of
the code, so I will not be using it. I have borrowed code
before, but I like to have some idea of what is going on.
I think I will just maximize the second tier forms, and
set the Activate(?) event to DoCmd.Maximize for the
switchboard and for the sub-tier forms. This way that
gray space won't fill the background (unless there is a
way of changing that background?). This should be simple.
Thanks again for taking the time to help.
 
It is good to know about that, and I have already put the
principle to use in other situations, but unfortunately it
won't help for the particular problem I outlined. I need
to preview reports from the second tier forms (the ones I
open from the switchboard), which I cannot find a way to
do as long as the form is set to modal and/or pop-up. The
report never comes to the top.
Thanks for taking the time to help.
 
That NOT what I wrote.

My suggestion does NOT need the Form to open in Dialog mode.

Check my previous post and read the article carefully.
 
Back
Top