How size the window a form appears in ???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed many forms, they are continuous forms , mostly about 6ins wide
When my VBA code opens each form, it appears in a window about 3x3 ins. The right side of the form is cut off and I see only one record in my continuous form instead of several. How do I get the windows to open at a pre-determined size??? I have tried resizing the window but the next time it opens, it reverts back to 3x3ins. This is absorbing a lot my development time. Thanks. Ryan.
 
How do I get the windows to open at a pre-determined
size???

Do you have the"auto-resize" property of the form set
to "yes"?
 
You have a couple of options to try depending on what you really want.

You can make the form maximized (but this will maximize all forms) by opening the form properties and clicking the ellipsis next to the "on open" line of the "event" tab, selecting "macro builder" and in the macro builder type "maximize" in the action box and save it. Then, when you open the form it will open full screen

or

If you only want that one form a different size (not maximized) you can resize the form in form view (not design view) and click save. Then close the database and open the database again. The form should have saved the size

Hope this helps
Crystal
 
Back
Top