Form size

[Michelle]

I have a switchboard and several forms I want the forms to
open maimized and then when you close them the switchboard
should come back up, which it does however it is maximized
as well, is there any way to keep it the same size at all
times?

 

[Jonathan Parminter]

-----Original Message-----
I have a switchboard and several forms I want the forms to
open maimized and then when you close them the switchboard
should come back up, which it does however it is maximized
as well, is there any way to keep it the same size at all
times?
.

Hi Michelle,
in a standard module add the following function:

Public Function SmallSize()
docmd.echo false
docmd.restore
doevents
docmd.echo true
end function

then enter:
=SmallSize()

in the property dialog for one of the following locations:
form close event
switchboard activate event
switchboard got focus event

you may have to experiment with each of the above location
options to determine which gives the best desired result.

Luck
Jonathan

 

[Marshall Barton]

I have a switchboard and several forms I want the forms to
open maimized and then when you close them the switchboard
should come back up, which it does however it is maximized
as well, is there any way to keep it the same size at all
times?

A neat trick that Albert brought to my attention is to set
the switchboard form's Min/Max Buttons property to None.