How to resize the form based on the computer resolution

[fluffyvampirekitten]

I am trying to locate any available code that will allow a form to open up maximized based on the screen resolution.


I've tried the below code but I'm still facing the same problem

DoCmd.Maximize

The application I am working on will be used on several different computers with several different monitors.

Any Ideas?
Thank you in advance

[ranman256]

Maximize is as big as it can get.

[ItsMe]

...
Any Ideas?

I build my apps for a minimum screen resolution. I have heard of ways of creating different forms for different screen res. and then call the correct form based on screen res. This has always sounded to me like creating two different applications, which I sometimes do anyway. The difference in my apps is that I do not combine two different apps into one. I create two different apps for two different minimum screen resolutions and distribute the appropriate application to a specific group.

[June7]

Forms can't be changed to suit screen resolution, not like I can set zoom magnification level on this web page. As already described, have to design objects to meet the expected screen resolution and monitor size. Could build duplicate forms in one database and depending on the username or maybe the computer name, both of which can be pulled with the Environ() function, open appropriate form. This would require a UserInfo (or ComputerInfo) table that documents setting preferences (resolution level) and then code would open appropriate form. I don't know if there is a way to pull the screen resolution settings from the computer system.

Not the first time this topic has come up.

[Micron]

I believe they can be, having read about this problem on and off for a number of years. However, I've never tried it because my philosophy is to develop for the most common resolution (unless directed otherwise by the end user) and let others deal with the issue as necessary. Sometimes, that would be having to use scrollbars where they didn't appear before. Sometimes, they have to adjust their monitor resolution - maybe permanently, and maybe just as long as they need the application. You should not have to be concerned about either a user's refusal to get glasses and move away from 800x600 monitor resolution, or a company that won't shell out a measly sum for a monitor to suit the business needs. What you are asking for is a one-size fits all approach, which you apparently can achieve for form size, but probably will not go for when you see what you're up against. Check out http://bytes.com/topic/access/answer...-resizing-code or any other web lookup you can find to see what I mean. If this daunts you as much as it would me, another option would be to create duplicate forms or reports and choose to open one or the other based on two possible scenarios. The biggest fault with your desired approach is that you could re-size the forms, but you cannot resize the controls on them. So you may end up with a scaled down/up form that has controls that become crammed, overlapping or just plain not visible.

[June7]

Right, code would have to change form dimensions, controls width/height/top/left, text font size, etc. Basically what would have to be done to build the multiple alternate forms. Essentially why I said can't be done because it is just so demanding a coding effort, especially if form has hundreds of controls.

[fluffyvampirekitten]

I build my apps for a minimum screen resolution. I have heard of ways of creating different forms for different screen res. and then call the correct form based on screen res. This has always sounded to me like creating two different applications, which I sometimes do anyway. The difference in my apps is that I do not combine two different apps into one. I create two different apps for two different minimum screen resolutions and distribute the appropriate application to a specific group.

How do you create two different minimum screen resolutions ? My current resolution is 1366 X768. One of my forms , I can't see the right side of my form, I have to go to Edit view and scroll to the right .

[fluffyvampirekitten]

How do i make it appropriate for normal size resolution? What is the common resolution?

[ItsMe]

I will typically choose between 11 inches wide or 14 inches wide. One application will have 11 inch wide forms and another application will have 14 inch wide forms.

[Micron]

How do i make it appropriate for normal size resolution? What is the common resolution?

I'm referring to whatever is "normal" or common within the organization. When I first started developing in Access, 800x600 was new - typical was 640x480 (yikes, I'm giving too much away!). Obviously, those db's (if they were still around) might appear small with a lot of space in the window on today's monitors. So if you build for whatever is most common in an organization, anybody with higher res should not have an issue. Those who are stuck with lower res but don't have to be, need to change. I worked for a place where some were still using 800x600 but refused to wear glasses, so I wasn't kidding. Anyone who was using 1366x768 had no issue while I developed in 1024x768. To me, creating two of everything just sounds like way more work than I was ever inclined to do, but I guess not all situations are the same.

[fluffyvampirekitten]

I understand now. Thank you so much