Microsoft Access 2013 form does not open the same size as I saved it

Posted on 2016-09-09
Medium Priority
Last Modified: 2016-09-09
I have an irritating problem that the "autoresize" property is supposed to take care of. When I open the form it opens showing only the first record and the form is only  3 inches high. I have to drag it down to resize. I save it in design view with the proper height and my autoresize property is set to true. Please help, thanks!
Question by:pabrann

Accepted Solution

TechieMD earned 2000 total points
ID: 41791382
In this instance, you would want the autoresize value to be false. A value of true automatically resizes the form to display a complete record, while false will use the last saved size. See here for more details.

Author Closing Comment

ID: 41791406
Thank you very much, that worked.
LVL 50

Expert Comment

by:Dale Fye
ID: 41791554
I like to use the Form_Open event to change the form size appropriately.

Private sub Form_Open(Cancel as integer)

    me.insideheight = 5 *1440
    me.insidewidth =  9 * 1440

End sub

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question