Fixed Window Size in MS Access

I'm in the process of creating an application in access and would like to know how to fix form size so that when each form opens it opens in its proper size.
jaimebcInformation Systems and Communications ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You define the size of the window directly from design screen. Just resize form when you design it and you will see it grows or shrink when you execute it.

Also, you can assign height and width form properties from VB code.

Hope it helps. Regards.
jaimebcInformation Systems and Communications ManagerAuthor Commented:
Thanks for the above, I'm resizing when designing it, but when running it goes to full screen. Not sure how to do it from VB Code
Maybe window is maximized. Try to put its state in restore (not maximized) mode.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Rey Obrero (Capricorn1)Commented:
set the option to use Overlapping Windows,
the default setting is using Tabbed Documents

to set this

access options > current database > applications options

check > overlapping windows
Also, set the form AutoResize property to Yes.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
You can use the Move method to set the location and size of your Form when it opens.
Set the Auto Resize , Auto Center and Fit To Screen Form properties to No.

Here is an example:

Private Sub Form_Load()
    Move Left:=1440 * 1, Top:=1440 * 1, Width:=Me.Width, Height:=Me.Section(acFooter).Height + Me.Section(acDetail).Height + Me.Section(acFooter).Height
End Sub

Also, the 4 arguments in the Move method must be in Twips. There are 1440 Twips per Inch. Note that the Section().Height and Form Width properties are already in Twips, so no conversion is necessary

The example shown will position the Form 1 inch from the Top and Left side of the Access application window.

You may need to tweak the Height and Width values .....


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.