• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 35574
  • Last Modified:

Access 2010: Setting Popup Form size and placement

I'm loosing my hair over this one in Access 2010:
I have created a Sizable form with a header/detail/footer.
I open it and it is full screen. Not Cool, so I change it to popup.

I open it in popup, set the size, save it and close it.
I then open it and notice that it's not centered on the screen so I change the position and save it
Cool. Just where I want it.

Now I go back into the design mode, change it to a THIN form. Save it and close.
Open it and AAArg! back to the popup size I had before.

What are the steps to size a form with a thin border and have it keep it's size/position after making design mode changes unrelated to the size?
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Have you tried:

change it to a THIN form, OPEN IT, SAVE, then back to Design view, save and close.
Jeffrey CoachmanMIS LiasonCommented:
...and set the "Auto Center" property of the form to: Yes
I have found that saving a form after changing the size and position alone usually does not save the new changes.  After making such revisions, I normally revise something else within the form such as move a control slightly, save, then move it back and save again.

Another way you can size and position the form (if you don't use the AutoCenter property) is by using the MoveSize method in the form's OnOpen or OnLoad event.
DoCmd.MoveSize Right,Down, Width, Height
The first 2 arguments specify the form position from the upper left corner of the application, and the last 2 are obviously the size.  The values for all these are in Twips and since there are 1440 Twips in 1 inch, the following will position a form 1 inch to the right and 2 inches down.
DoCmd.MoveSize 1440, 2880
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

GNOVAKAuthor Commented:
I would rather not do it with code if I can help it.
The form has been made to a continuous form. The size comes up way too long (the footer is well below the fields.  So I have :
AutoCenter - Yes
AutoResize - No
Fit To Screen - No
Border Style - Sizable
Record Selectors, Navigation, etc all set to No.
I can resize, save and open and its OK.

Now if I go into the design view and change it to Thin, I'm back to a larger screen.

I can limit the width my moving the property sheet on the right over making the property sheet wide and the width of my form, the desired size.
But I dont have any way to do the same for the height.

The only way I can get it the way I want is to leave it in Sizable mode to Yes, save it.

It seems Access does not respect the size of the form drawn in the design mode.
Does that mean I cant control the size from a GUI for the THIN or non-sizable mode?

Jeffrey CoachmanMIS LiasonCommented:
I agree with the other experts...
I cant really replicate your issue in Access 2010, with what we have recommended...

But lets go back...
<I have created a Sizable form>
I try to avoid user sizable forms, I try to design the form to be a good size with our companies common resolution of 1024x768.
I mean, if they have a list with 100 items, then they will have to scroll...
It does not matter how "sizable" the form is, if they have 200 items, there is no way they can size the form to see all of the items...

I rarely have a need to make a "pop-up" form sizable, ...to me this defeats the purposes of having it "Popup"...
In other words how is your data growing and shrinking (horizontally or vertically) such that the user has to have the ability to re size the form?
Just curious...

Yes, I know that sometimes a sizable form is needed, ...
I think this is the reason why the "Tabbed" documents window option was created.
I think MS realized that many forms contain so much data (these days)  that it just makes sense to make all forms the size of the application window.  Then resizing, moving, borders, min max buttons, ...etc, ...all become irrelevant at some point.
So have you considered this option?

Take for example the email window.
There is so much data there now that you might have to resize it to see everything.
Now take the form wizard dialog box, ...you cannot resize it, ...so if your source has more then 8 field, you have to scroll.  So why doesn't MS make all "windows" sizable...?

Then consider user monitor resolution..
If a user wants to set their resolution to 15360 × 8640, then they may not ever have to scroll a window.
Likewise, a person who needs 640x408 may be forced to scroll almost all forms.

< with a header/detail/footer.>
Lets be clear, Form header or Page Header>
Form Footer of Page Footer?

GNOVAKAuthor Commented:
Agreed - The only reason I have used a sizable form is so that *I* can size it to the size I want.
I thought there might be  GUI way to size the form.
I have decided to go with manual sizing in the form load. A little painful and time consuming, but it works,
Jeffrey CoachmanMIS LiasonCommented:
Still I could not replicate your issue.
(I create the form, size it, save it, and it is always the size I set it to.)

So make sure you try all the suggestions posted.
Or post a database with a form that exhibits this behavior... so we can test this for ourselves...
GNOVAKAuthor Commented:
Is this the same for reports? I tried placing the movesize in the Report Load and open with no luck.
Jeffrey CoachmanMIS LiasonCommented:
Move size works just fine for me on a report...

Perhaps your db is getting corrupt
Run the compact/repair utility, then test again

If not, then create a new database and import all the objects , then test again...
Since this Q decided to be cast up in the right-hand column even though it was completed long ago, and I know more than a little about how to get this done with complete precision, I'll post the link


Ed RederCommented:
I have worked with MS/Access for many years.   I am use to that when I save a query the size of the lower portion of the query where you specify what data fields are being used stays the same size.  If i save the query and then reopen it, the size of this has increased.  I don't know why this happens or how to prevent it.

For example, if i save a Select type query that have six blank lines after "or:" line, when i re-open it, it now has seven blank lines after the "or:" line.  

I also have the same problem with keeping the form size within the database window.  I will try some of the above solutions.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now