open form in a NOT maximzed view

[markjkubicki]

this one I ought to know, but it seems to be a constant and recurring issue...
I simply want to open a form in it's designed size; not across the entire screen !

so this in my code:

DoCmd.OpenForm "frmContactInfo", acNormal, , "[Manufacturer] = '" & Me.Manufacturer & "'"

BAM! full screen!
aurghhh

many thanks in advance,
Mark

[Dal Jeanis]

Check out Docmd.Restore, Docmd.MoveSize, DoCmd.Maximize, DoCmd.Minimize.

[Missinglinq]

Versions 2007/2010/2013 has a new option called Document Window Options, and it defaults to 'Tabbed Documents,' which means that all Forms open Maximized, regardless of their designed size. To make them behave as they did in Version 2003 and earlier

[list=1]
[*]Go to Office Button (Big Icon, Top/Left)[*]Click on Access Options (bottom, right of Dialog Box)[*]Click on Current Database[*]Under Document Window Options tick Overlapping Windows[*]Click on OK (Bottom, Right)

With this Option chosen, the Form will display, as designed, unless it is opened from another Form that was Maximized. If that is the case, DoCmd.Restore will, indeed, bring it down to its designed size.

Linq ;0)>

[markjkubicki]

DoCmd.Restore <-- exactly !! thanks