Keep forms from maximizing on open?

JCross

Registered User.
Local time
Today, 10:27
Joined
Feb 28, 2002
Messages
116
I know there has to be an easy answer to this question, but it's driving me crazy! How do I keep my forms from maximizing when they are opened??

Jennifer
(thank you!)
 
How about "DoCmd.Restore" on the on_open event of the form?
 
It doesn't work
frown.gif


All I want is for the form to be small on open instead of full screen! Seems like this must be easy.....

It's not a pop-up or modal (i don't want it to stay on top, or close before going to another form)

HELP!

I think I got it - I changed the border to dialog and it seems to work.


[This message has been edited by JCross (edited 05-30-2002).]
 
You just need to set the PopUp property to Yes.
 
whats the size of form, maybe you form is too big?

If form isnt big try this:
when form is open go to Windows on Menu bar and choose "Size to Fit", save form and put this code on OpenEvent of form.

"DoCmd.Restore"
 
Last edited:
Try this in the forms OnOpen event to force the forms size to exactly what you want...

Code:
    MsgBox "InsideHeight = " & InsideHeight & vbCrLf & vbLf & "InsideWidth = " & InsideWidth [COLOR=SeaGreen]'for testing the actual size[/COLOR]
    InsideHeight = 5180
    InsideWidth = 7210
 
Size a form to fit its contents
Open a form in Form view.


Click Size To Fit Form on the Window menu.
Note If the Form window is maximized, the Size To Fit Form command is unavailable.

Click Save on the toolbar to save the size of the form.
When you click Size To Fit Form, Microsoft Access adjusts the size of the form depending on whether the form's DefaultView property setting is set to Single Form or Continuous Forms.

Single Form. If the displayed record is smaller than the Form window, Size To Fit Form crops the window to the size of the record. If the record is larger than the Form window, Size To Fit Form expands the Form window to show as much of the record as possible.


Continuous Forms. If only part of the bottom record is displayed, Size To Fit Form crops that record. If only one record is partially displayed, Size To Fit Form enlarges the window to show as
 

Users who are viewing this thread

Back
Top Bottom