Have a form of a specific size display in that size rather than the whole work area

[GeorgeJ]

Hello,



I create a form in the design view. The form has a specific size in the Design View, but when I run the form, either by double clicking on it or through code, the form occupies the entire part of the screen used for forms, tables, queries, etc. I have tried setting the autoresize property to "no" but that doesn't help. A book on Access VBA mentions something called Docmd.MoveResize but I can't find any examples of its use, even in the online database connected to the help button in Access VB. Any help would be greatly appreciated.

Thanks in advance

[June7]

Is the db set for Tabbed Documents? Try Overlapping Windows.

File > Options > Current Database > Document Window Options

[GeorgeJ]

Thank you. Thanks to your suggestion, I'm half way (maybe) to where I want to be. I changed the option to "Overlapping Windows" as you suggested.


Here is where I am now.


When I open the form, it no longer occupies the whole works area, but definitely occupies an area larger than the size suggested by viewing the window in design mode. I double-click the form, it displays, and it now has a close button and I now am able to resize it while it is displaying, but then I close it and when I reopen it is back to its original size (too-big) size. My goal is to have the form occupy the same amount of real estate as indicated by viewing it in Design Mode, and not give the user the option of moving it or resizing it.

Any suggestions?

Any way to have the form's display location and size controlled by VBA code?

[GeorgeJ]

I'm adding to my previous reply, in case this may be helpful to other newbies perusing this forum. I just discovered the other half of the riddle.

I followed June7's suggestion:

File > Options > Current Database > Document Window Options then set for "Overlapping Windows"


After I did that I noticed that when I view a form in the design mode the form appears within a window which can be resized ( this wasn't the case before I made the modification that June7 suggested). If I resize this window to just accommodate the form, then when I show the form it will appear the size of the window.

Problem Solved.

Thanks

[June7]

Also, the BorderStyle property determines if the form is resizable in form view. And the Moveable property is self-explanatory.