forms changing size

  • Thread starter Thread starter Old Guy
  • Start date Start date
O

Old Guy

I have a sybform that opens upon clicking a command
button. one time it will open in the correct size and
another time it will open up in full page size. after the
size of this form changes I also find other forms start
opening in full page size. how do I control these form
sizes. I'm 70 year old legacy guy who hasn't coded since
pl/1 or cobal days so please no code answers just tell me
how to use property settings or macro settings.
thanks
 
copy these code to your form model

Private Sub Form_Open(Cancel As Integer)
DoCmd.Restore
End Sub
 
thanks but as I don't do code I don't even know where to
try and copy this to -it would be better if you could tell
me what settings I could use in the forms properties
 
thanks but as I don't do code I don't even know where to
try and copy this to -it would be better if you could tell
me what settings I could use in the forms properties

Somewhere in your app Maximize is getting invoked. In Access if you
maximize one, you maximize all. So you either have to never maximize
anything or use the code suggested to revert back. If you don't want to use
code then just press the restore button on the form whenever this happens.
 
Old Guy said:
I have a sybform that opens upon clicking a command
button. one time it will open in the correct size and
another time it will open up in full page size. after the
size of this form changes I also find other forms start
opening in full page size. how do I control these form
sizes. I'm 70 year old legacy guy who hasn't coded since
pl/1 or cobal days so please no code answers just tell me
how to use property settings or macro settings.
thanks
Click to expand...

Ok, I will give you a few "pointers"

if you open form "a", and then that form opens form "b". All is well.
However, if you hit the little [] squire thing in upper right to "max" the
form, then the form will max. If you now close this form B, and return to
form A, you will find that formA is maximised. In fact, you will find all
forms maxed.

So, as a general rule, when you maximize one form, all the other forms will
also maximize when you return to them.

However, there is a few things you can do:

Don't max the forms!

In addition, you should also set the forms property sheet while in design
mode:

I would set the forms "auto center" property to yes.
I would set the forms "auto re-size" property to NO

Further, if you actually size the form exactly the way you want, and then
save the form, you can now open the form in design mode, and change the
border style to "thin". This mans that you, or your users will NOT be able
to change the form size (as a general rule..that is how I design my forms
anyway).

So, really, to control this max/min issue. you don't need any code...but you
do have to pay attention to the forms settings.

If you don't want you, or users to min/max the forms, then you can remove
this option in the forms properties setting. Just change the min/max Buttons
setting to "none". If the this "min/max buttons" form setting is none, then
even if a form on top is maxed, when you return to the previous form, it
will NOT be maxed since the min/max buttons setting is gone!
 
TTHANKS FOR THE LESSON-The book I've learned access from
doesn't tell me this anywhere-you've been a great help
-----Original Message-----
I have a sybform that opens upon clicking a command
button. one time it will open in the correct size and
another time it will open up in full page size. after the
size of this form changes I also find other forms start
opening in full page size. how do I control these form
sizes. I'm 70 year old legacy guy who hasn't coded since
pl/1 or cobal days so please no code answers just tell me
how to use property settings or macro settings.
thanks
Click to expand...

Ok, I will give you a few "pointers"

if you open form "a", and then that form opens form "b". All is well.
However, if you hit the little [] squire thing in upper right to "max" the
form, then the form will max. If you now close this form B, and return to
form A, you will find that formA is maximised. In fact, you will find all
forms maxed.

So, as a general rule, when you maximize one form, all the other forms will
also maximize when you return to them.

However, there is a few things you can do:

Don't max the forms!

In addition, you should also set the forms property sheet while in design
mode:

I would set the forms "auto center" property to yes.
I would set the forms "auto re-size" property to NO

Further, if you actually size the form exactly the way you want, and then
save the form, you can now open the form in design mode, and change the
border style to "thin". This mans that you, or your users will NOT be able
to change the form size (as a general rule..that is how I design my forms
anyway).

So, really, to control this max/min issue. you don't need any code...but you
do have to pay attention to the forms settings.

If you don't want you, or users to min/max the forms, then you can remove
this option in the forms properties setting. Just change the min/max Buttons
setting to "none". If the this "min/max buttons" form setting is none, then
even if a form on top is maxed, when you return to the previous form, it
will NOT be maxed since the min/max buttons setting is gone!


--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.attcanada.net/~kallal.msn


.
Click to expand...
 
TTHANKS FOR THE LESSON-The book I've learned access from
doesn't tell me this anywhere-you've been a great help
Click to expand...

You are most welcome. I been meaning to write a nice little article on this
behaviour, as it was a source of frustration for me when I started out also!
 
Back
Top