Cascade Forms

[Perceptus]

Greetings,



I have several instance of forms that I have opened that I would like to have cascade across the screen.

I am currently using Access Version 1710(Office 365 ProPlus)

DoCmd.RunCommand acCmdWindowCascade

This is what I want, however the windows get resized to be bigger than the form actually is and I end up with them being about screen width, when they need to be about half that.

Any suggestions?

[June7]

Did test. All windows are the same size and proportional to the app window, about 3/4 the app width.

[Perceptus]

Exactly, I would like them to not have their size changed. Just the position within the app.

[June7]

Doubt that is possible with nature of cascade.

If you want to control form position in the Access window then use Move method https://msdn.microsoft.com/en-us/vba...-method-access

[Perceptus]

That works.

I ended up using

arrForms(n).Move arrForms(n).WindowLeft, Width:=11175 ' 11175 is the original window width

Thanks for the idea!