Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Forms change size 1

Status
Not open for further replies.

sawilliams

Technical User
Aug 23, 2006
98
US
This is really peculiar. I am creating a very simple little db to demo how my user can store info. When I create a form with the Pop Up property set to Yes, the form will not retain the size it was in design view. I have created dozens of Access dbs (of one sort or another) and created literally hundreds of forms. All new forms (pop up) in ANY new db I create have the same resizing problem. If I open an older db, the forms behave themselves and size to my specs. If I import a form from an older db into the new one, the "old" form behaves normally. I can go to design view and resize to my heart's content. But any new forms resize to some size other than what I specify. I'm baffled. Did I unwittingly change some setting? I'm on the same pc with the same version of Access for all these db's.
 
Have you looked at the auto resize property?
 
I've turned it on and off. I have compared each property from the forms that behave to the forms that misbehave and they are identical. Still the good ones created in databases from some time ago (say a month) are fine, and the bad ones that were created today suffer resize disfunction.
 
Tried them all, BorderStyle(s) that is. Same issue.

But that was yesterday. Today, I am able to resize normally in ANY db I open. It appears to have been a temporary glitch -- I know, that sounds really technical, right. But I have no idea how to explain what happened. But it seems to be fixed. Thanks for the responses. It's always great to know there're people out there who are quick to help...
 
I had the same problem swithching between 2007 and 2000, I shut everything off and found - auto center is the culprit.
 
sorry - my problem came back - it opens ok twice - but the third time it resizes. :-|
 

sawilliams,

Try this: In Form Properties, try setting these values

Default View = Single Form
Borderstyle = Dialog
Auto Resize = No

Also, keep the design window close to the forms borders when the form is in design mode.

Hope this helps.
 
I ended up using this code in the onload event to get around the problem of resizing in 2007

'Manually Move and Size Your Form
'1440 = 1 in.
'Order is left,top,wide,tall

DoCmd.MoveSize 1440, .5*1440, 8 * 1440, 5.75 * 1440

My Form example is
1 in from left, 1/2 in from top, 8 in wide, 5.75 in tall


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top