Forms layout/size acting erratic...help!

[Lateral]

Hi guys

I am having a nightmare with a number of the forms that I have in my database.

I am using a template database that I downloaded from the Microsoft Access template website and have been modifying it and adding new forms and tables etc. I have used the forms wizard to create a number of new forms to edit a number of the tables. The forms are "split forms".

I can't seem to get many of the forms to stay the size that I set them to! They seem to have a mind of their own and often when I think that I have sized them correctly, I then open the form and they display in full screen mode or larger!

What am I doing wrong?

Thanks for any help you can provide.

Regards
Greg

 

[AlexHedley]

Do you have Access set as Overlapping Windows of Tabbed Documents, I presume OW.

When you have sized the form are you saving, this should save the Size and Position of the Form so if you close and re-open it will show in the same place.

Are there any events running on the Form, macros or VBA?
It could be that the Template has some code that changes this on load or on open etc.

 

[Lateral]

Hi Alex,

I am using OW and I am saving the forms after I change the size etc. There are no events.

Regards
Greg

 

[missinglinq]

In Form Design View, for the Form, itself, go to Properties - Format and set the Auto Resize Property to No and save the Form immediately and close.

Linq ;0)>

 

[Lateral]

Hi Linq,

The Auto Resize is already set to "NO"

 

[Cwire]

I'm having the same issue, I've resized my "Main Menu" form set the Auto Resize to NO and it is still coming up full screen. I'm using Access 2010 and am Stumped.

 

[missinglinq]

Many things work differently in post-2003 Databases because of the Document Window Options, a new option with 2007/2010, which defaults to 'Tabbed Documents.' Changing this option to Overlapping Windows basically causes many things in Form Design to act like they did pre-2007, including Forms to display as sized as opposed to full screen.

Step-by-Step for For 2010

1. Click on FILE in the menu (top left)
2. Click on OPTIONS (just above EXIT)
3. Click on Current Database in left hand pane
4. Under Applications Options, look for Document Window Options, tick Overlapping Windows
5. Click on OK (Bottom, Right)
6. Close the Message box, then Close and Re-open Access

Linq ;0)>

 

[Cwire]

Perfect Thank you

 

[missinglinq]

Glad we could help!

Linq ;0)>