[RESOLVED] Set the startup position of a form

**Santos7772005** · May 15th, 2006, 09:00 PM

Is there a way in Access to make a form startup in a position other than automatically centered? Ideally, what I would like to do is have the form get the position of the form it is opened from and then position itself say 20 pixels down and to the left of the parent form.... any help much appreciated. vbforums is a lifesaver !!

**RobDog888** · May 17th, 2006, 10:36 PM

Thats sounds like you want Cascading Window layout?

**Santos7772005** · May 17th, 2006, 10:46 PM

Yes! Thats it exactly. I thought it would be quite easy to do but I have to admit its got me stumped.

**RobDog888** · May 17th, 2006, 11:02 PM

I'm just getting ready to start installing Office 2003 SP2 on my system, had to reinstall eveerything after a hd failure.

Give me a few more minutes to install it and I will whip up some code for you.

**Santos7772005** · May 17th, 2006, 11:23 PM

You are a legend my friend!

**RobDog888** · May 17th, 2006, 11:45 PM

Flattery will get you everywhere!

**dmaruca** · May 17th, 2006, 11:50 PM

Hey, if all you want to do is cascade the windows, have you tried this?

docmd.RunCommand acCmdWindowCascade

if you want more control there is another way but i can't seem to remember it right now

**RobDog888** · May 18th, 2006, 12:15 AM

Just finished installing and you beat me to it.

VB Code:

Public Function CascadeMe() As Boolean
    On Error GoTo MyError
    Application.DoCmd.DoMenuItem acFormBar, 4, 1
    CascaseMe = True
    Exit Function
MyError:
    CascadeMe = False
End Function

**Santos7772005** · May 18th, 2006, 12:18 AM

hey, thats great, thanks guys.

Thread: [RESOLVED] Set the startup position of a form

Thread Tools

Display

[RESOLVED] Set the startup position of a form

Re: Set the startup position of a form

Re: Set the startup position of a form

Re: Set the startup position of a form

Re: Set the startup position of a form

Re: Set the startup position of a form

Re: Set the startup position of a form

Re: Set the startup position of a form

Re: Set the startup position of a form

Posting Permissions