Form dimensions on display as modal window

[PaquettePaul]

I am working through the forms in 2019 Access as i migrate from 2003.

in 2003, I would simply adjust the size of the design window to reflect the actual size of the display window when the Form is opened. The form design window and the properties sheet were detached from each other and the design window was sizeable.

now, I am designing forms in 2019 and I find that the form design window (and it’s display size) cannot be adjusted. Both the design window and the “open” version take up the full screen. Am I missing something or did MS Access drop some capabilities along the way. Is there any way to adjust the window at design time or does it now have to be done with vba?

 

[arnelgp]

i think you need to "drag" the right or bottom edge of the form, in design view to resize it.
or when the form is opened (normal view) you can resize it and Save (ctrl-s) to save the
current window size.

 

[theDBguy]

Hi. Not sure if this will help but go to File > Options > Current Database > Document Window Options > Overlapping Windows

 

[arnelgp]

if post #3 is true, you can also set that in Design view of your form (Property Sheet->Other->Pop up->Yes)

 

[GPGeorge]

I am working through the forms in 2019 Access as i migrate from 2003.

in 2003, I would simply adjust the size of the design window to reflect the actual size of the display window when the Form is opened. The form design window and the properties sheet were detached from each other and the design window was sizeable.

now, I am designing forms in 2019 and I find that the form design window (and it’s display size) cannot be adjusted. Both the design window and the “open” version take up the full screen. Am I missing something or did MS Access drop some capabilities along the way. Is there any way to adjust the window at design time or does it now have to be done with vba?

A few years ago, I think in Access 2007 in fact, Microsoft introduced the new method of displaying forms as an alternative to Overlapping Windows. It's called Tabbed Documents. The default is now Tabbed Documents. Follow theDBGuys directions to restore Overlapping Windows.

 

[PaquettePaul]

Yes, changing to overlapping forms did the trick. Now I can fix the size of the opened form window to my requirements. And after saving the form, the dimensions and placement remained the same. For the invoked/opened forms from the main menu, I adjust the placement before display using vba code - that way it does not matter what the user does, the x:y placement axis on opening is always the same.

you guys are awesome again

 

[theDBguy]

Yes, changing to overlapping forms did the trick. Now I can fix the size of the opened form window to my requirements. And after saving the form, the dimensions and placement remained the same. For the invoked/opened forms from the main menu, I adjust the placement before display using vba code - that way it does not matter what the user does, the x:y placement axis on opening is always the same.

you guys are awesome again

Hi. Glad to hear you got it sorted out. We were all happy to assist. Good luck with your project.