How to show the complete form on laptop screen?

The screen is Shrinking when run my app on laptop always. So it won't show the bottom part of application on the laptop screen. Look my images may it will clarify my problem.
please help me.
screen One, is what should I see.
screen One what should I seeScreen Two, what happen when I run my application on a laptop, where you can see the buttons down in the form is not shown
screen Two
Mohammad Alsolaimanapplication programmerAsked:
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.

Gustav BrockCIOCommented:
To state the obvious: Redesign the form having reduced height.
Mohammad Alsolaimanapplication programmerAuthor Commented:
You know, I truly try to avoid this choice. I have a plenty of applications using the same template. So I don't want to go with this approach.
Gustav BrockCIOCommented:
Laptops and, indeed, tablets have some options for scaling, though mostly for fonts. But that will influence most applications, or perhaps not yours of Access.
Maximize Customer Retention with Superior Service

The IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more to help build customer satisfaction and retention.

Mohammad Alsolaimanapplication programmerAuthor Commented:
I'm watching some videos talking about Laptops scaling & I'll try it & reply to you in sh Allah.
Gustav BrockCIOCommented:
You could check out Peter's Software:


I've never used it, so I can't comment on its capabilities.
Jegajothy vythilingamretiredCommented:
i had the same problem years ago, and I remember using a function that will resize the form to whatever resolution screen the form is displayed on.  But alas it was very long time ago, hope the current geeks can recollect it.  ///see Ashish's site if he has anything.

you have two more options to get more space for your form: Just doubleclick on any of the ribbons tabs, that reduce the ribbon and it will open when you click on a tab temporarily only. The second option is to do the same with your taskbar, so that it automatically hides when you do not need it. On this way you get a lot more vertical space on your screen.

Next is, simply reduce the vertical size of the form (the window size) so that it always fits to the current screen resolution and enable it to display a vertical scroll bar. On that way you can at least scroll down the form to access the buttons if you do not want to redesign the form.

In general, I would try to avoid such big headers with a logo which doesn't help your application. If you want, you could display a logo in the ribbon as a button for i.e. an "about" function.

Another possibility is to move the buttons into the forms footer. A footer will always be shown and instead the detail area gets a vertical scroll bar. Also in this case of course the form should be displayed in the correct window size. I recommend to switch from form mode to tabbed mode, in this case the whole application window is used and you do not need to check the resolution or resize the forms window, the application window is then already aware about that and shows the vertical scrollbar if needed (and if not disabled in the forms properties).


Mark EdwardsChief Technology OfficerCommented:
I didn't see it mentioned, but if the user only needs the controls on the form (no ribbon or other controls outside the form), then you can set the Popup and Modal properties of the form to "Yes" which would allow the form to expand outside the Access application (up to the size of the whole screen), but you can't mess with any other part of the Access app until you close the form.

You can control the size of your form by putting VBA code in the Form_Resize() event to set the width and height to the proper size, or you can just put Docmd.Maximize in the Form_Load() event to automatically make it the size of the screen (if you don't mind the oversized look).

There are Win32 API calls for getting the screen resolution that you can use in helping to set your form sizes.
Mark EdwardsChief Technology OfficerCommented:
Also, it helps to a know a few tricks, like if you open your main form with both its PopUp property and its Modal property set to "Yes", then you just need to set the PopUp property to "Yes" (leave Modal at "No") for any forms opened from your main form and you can switch from one form to the other and back (like a regular application), but you can't touch the Access MDI (the part of Access with the ribbon and navigation pane) as long as you have the modal main form open.

To see this in action, you see it on YouTube at Creating an Access Application Shell

Works like a charm.....
Dale FyeOwner, Developing Solutions LLCCommented:
can you not simply change the display resolution on the laptop?
Mark EdwardsChief Technology OfficerCommented:
@Dale:  That would be too easy.  Besides, it isn't an Access/VBA solution ;-)
I swear the aspect ration on laptops is different from desktop monitors and people also tend to use lower resolution settings causing everything to be bigger.  So, if I know ahead of time that the app will be run on laptops, I design for the constraints of the laptop.

I have also used ShrinkerStretcher as recommended by Gus and liked it a great deal.  My client however did some seriously crazy stuff while testing and managed to get the ShrinkerStreatcher code to loop to the point of reducing forms to postage stamp size.  I could never reproduce the situation while the debugger was running so it must have something to do with events or timing.  Since I couldn't fix the code, I just fixed all the forms on this particular app.  I did use the product for other apps though.

I agree with the comment regarding useless headers.  This is one of the reasons I hate most web apps.  It's like the developer wraps himself up in creating a pretty banner  that takes up 25% + of the vertical space and consequently reduces the usable space for real data.  Web pages always make you scroll so apparently no one complains except me because I don't want to scroll unless the form is actually a list.

Lots of other excellent advice that I will look into for myself.
Hi Pat,

it's not only you, I also hate these new web layouts with parallax scrolling and 5% information on a looooong page which would fit on one page without scrolling. I don't understand why so many web designers follow such stupid layout which is really annoying for the reader. It's the same like with all these super thin fonts which are "modern" - it was so good in the first 10 years of the century when most sites had a navigation menu on the left, a small menu on the top and condensed content with as good as no scrolling at the detail pane where you quickly can find everything you want to know. And I think especially in an application that's the way to be able to quickly interact with the application, not biiiig forms with huge text boxes where the contents is small and the elements are spread with a lot spacing between them - not helpful for the user as we can see here in different resolutions.


Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Newer versions of Access also have the Anchoring methods. I don't think those are going to help (ShrinkStretcher is probably your best bet) but it might be worth a look.

You could also move those buttons to the Form Footer, which should make them always show.
I have never had much success with the anchoring methods.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I have used Peter's ShrinkerStretcher multiple times and it's truly amazing, taking into account so many things. Small price to pay for amazing functionality.  You can download and try for free as well.
Mohammad Alsolaimanapplication programmerAuthor Commented:
Wonderful debate,
& very sorry for late
I am using laptop only for viewing my application to customers.
I had find 15 screen resolution settings. I had try most of them, and com up with this one in the picture bellow.
As you can see, I unexpanded the ribbon so I can get more space.
Gustav Brock
As you can see, sometime the form is full of controls where you can't compress it any more.
According to Peter's Software I try it long time ago and my decision was not to go with it because I was afraid of right to left & Arabic language mismatching.
"In general, I would try to avoid such big headers with a logo which doesn't help your application" & "move the buttons into the forms footer". I like it & and I'm gonna use it in future in sha' allah.
Mark Edwards
" set the Popup and Modal properties of the form to "Yes" which would allow the form to expand outside the Access application ". I like it and I'm gonna try it later on.
I watch the video " Creating an Access Application Shell " awesome.
Dale Fye, & Mark Edwards
" can you not simply change the display resolution on the laptop? ". In fact, this is what I went to.
PatHartman & Bitsqueezer
I agree your advices 100%.
Mohammad Alsolaimanapplication programmerAuthor Commented:
as can see, it's hard to say that one of these solutions is the correct one. it depend on several things and situations. please forgive me if I wasn't fare with some of you. but for sure I had learn from all of you.
thinks to all of you.
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.