Window size - continuous forms

[Guest]

I have tried changing the window size of a continuous form.
If I open the form on it's own it works fine.
However the form is a pop up based on criteria when opening another form.
When it opens as a pop up it maximises the window to fit the screen.
Any suggestions greatly appreciated.

 

[tina]

try adding the following code to the pop-up form's Load event procedure, as

DoCmd.Restore

hth

 

[Guest]

Thanks,
I tried that but it does not seem to work.

 

[tina]

my only other suggestion is to keep the Restore code, and also change the
form's Modal property to Yes.

hth

 

[Guest]

Thanks for the help Tina.
Maybe I've entered the code incorrectly?

See below:
Private Sub Form_Load()

DoCmd.Restore
Exit Sub

End Sub

 

[Guest]

Tina,
D'oh: I went through some macro's and found a macro that opens this pop up
form. In the macro I had a maximise action.
It now works.
Sorry to waste your time but thanks for the help!

 

[tina]

you're welcome
and btw, on the Load event code you posted, you don't need the Exit Sub
line, because the very next line is End Sub.

hth