Not working on the button to open the form, not working on the On Open event
for the form itself. It maximizes instead.

It's gonna get tossed out the window (literally) unless someone can help.
Thanks!

Well for one thing it's MoveSize......

I'd create the following in a module:

Public Function fMoveSize()
DoCmd.MoveSize 1, 1, 14000, 9000
End Function

Then in the form's On Open event I'd put something like below:

Private Sub Form_Open(Cancel As Integer)
fMoveSize
End Sub

Now it could be maximizing because
(1) You have too many twips in the MoveSize arguments.
(2) Somewhere else in code you have a maximize statement.
(3) You have a maximize statement on another form or report but not a
DoCmd.Restore when that form loses focus or is closed.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Anne" wrote:

> Not working on the button to open the form, not working on the On Open event
> for the form itself. It maximizes instead.
>
> It's gonna get tossed out the window (literally) unless someone can help.
> Thanks!

I'm not sure what you are attempting, but DoCmd.Restore will restore the
form down from maximized.

Maybe if you posted your code and what you want to accomplish with it, we
can be of more help.

--
Bill Mosca, MS Access MVP


"Anne" <(E-Mail Removed)> wrote in message
news:B8B213DA-01E9-4F13-B90E-(E-Mail Removed)...
> Not working on the button to open the form, not working on the On Open
> event
> for the form itself. It maximizes instead.
>
> It's gonna get tossed out the window (literally) unless someone can help.
> Thanks!

You could also create a macro with the movesize command, and attach that to
On Click; you may have better luck positioning your form on the screen that
way.
The macro builder lets you input "right", "down" [to position the top left
corner of your window] and "Width", "Height" to set the size of your window.


"Bill Mosca, MS Access MVP" wrote:

> I'm not sure what you are attempting, but DoCmd.Restore will restore the
> form down from maximized.
>
> Maybe if you posted your code and what you want to accomplish with it, we
> can be of more help.
>
> --
> Bill Mosca, MS Access MVP
>
>
> "Anne" <(E-Mail Removed)> wrote in message
> news:B8B213DA-01E9-4F13-B90E-(E-Mail Removed)...
> > Not working on the button to open the form, not working on the On Open
> > event
> > for the form itself. It maximizes instead.
> >
> > It's gonna get tossed out the window (literally) unless someone can help.
> > Thanks!
>
>
>

MoveSize won't work on a (currently) maximized Form!

You need to use Restore before Maximize like

Application.Echo False, "Processing ..."
DoCmd.Restore
DoCmd.MoveSize 0, 0, 5000, 5000
Application.Echo True



--
HTH
Van T. Dinh
MVP (Access)



"Anne" <(E-Mail Removed)> wrote in message
news:B8B213DA-01E9-4F13-B90E-(E-Mail Removed)...
> Not working on the button to open the form, not working on the On Open
> event
> for the form itself. It maximizes instead.
>
> It's gonna get tossed out the window (literally) unless someone can help.
> Thanks!