How to set correct form size

[nzlowie]

Hi all

I'm revisiting a data base I built many years ago, it was written wen I had a CRT monitor! The main form was full screen, now it can be run on different screen sizes and resolutions which means the sizing is all over the place.

Is there a way to design my main screen so that it will be full screen no matter what screen and resolution I run it at?

Also looking back at my original I can see many differences between forms, is there a way I can copy the layout of a form so I can change all the forms to the same layout?

Appreciate your help.



Dave

[June7]

I don't use the Tabbed Documents option for db design but maybe that would accommodate your requirement. Otherwise, really have to design for smallest screen and lowest resolution of all your users or else those old tech users will just have to put up with the inconvenience.

I have read threads about coding to dynamically change resolution and sizing - don't remember if any are successful. Because, really, users would get upset if you changed their screen resolution for the convenience of 1 app.

What do you mean by 'copy the layout'? You can copy/paste controls. But there is no way to make a form adopt properties of another form, at least not without a lot of fancy VBA code.

[Missinglinq]

This might help:

http://www.utteraccess.com/forum/Res...Post182520&Zp=

Here's a link to a commercial app that does work in 2010/2013. They allow a free demo download.

Resize Microsoft Access Forms with ShrinkerStretcher from Peter's Software

There are other similar hacks, but the one caveat is that they work best when upsizing, so it's best that the Form(s) are developed in the smallest resolution you're apt to encounter.

Linq ;0)>

[Micron]

Is there a way to design my main screen so that it will be full screen no matter what screen and resolution I run it at?

The app will maximize according to the resolution, so if by "main screen" you mean what I know of as a switchboard form, simply maximize it on opening if the db form view property is set to "overlapping windows". Subsequent forms should open maximized and the underlying form that comes back into view should be maximized again. However, if you don't open other forms maximized, I believe the underlying form will open to the size it was saved at. To get around this, you might need a maximize event, but it would require some sort of vba trick or API call to get it to run since the form activate event does not fire on the underlying form simply because you closed some other form. You could also use the tabbed form option as June7 suggested.

is there a way I can copy the layout of a form so I can change all the forms to the same layout?

Maybe I don't get the question, but if the'yre all going to be laid out the same, it would seem they'd all have the same controls, buttons, labels, etc. In that case, why not just re-use the same form and set the object properties depending on user action?
Or if you're referring to having many properties e.g. background color, button properties, etc. to be the same, then create a template form and copy/save as when you need another one.