how to make fit on screen of ms access form?

[alex_raju]

hi,



i have ms access form, how i can make fit on screen type? ( like if monitor size 15.6" form should show full screen at the same time even 18" also it should show full screen


thank you

alex

[rpeare]

There's on easy way I know of to do this (I think what you're talking about is something like the fit to page property when printing reports) Your best bet is to design your database with the lowest common denominator

[ajetrumpet]

hi,

i have ms access form, how i can make fit on screen type? ( like if monitor size 15.6" form should show full screen at the same time even 18" also it should show full screen


thank you

alex

maximizing it when the form is opened, Alex. That's all you need to do. The only issue that would result from that would be the re-positioning of the controls that you would see. I believe some of the properties that affect these movements are those like "left anchor" and "right anchor". So if you try this right now, more than likely when you move from a 15" screen to an 18" screen you will see all of the controls move to the left and see more used space on the right side of your form.

That will take experimenting on your part to get all of that stuff right. I would go this route myself but absolutely despise Access's uneccessary complications with forms. My alternative to this is to center every form and set a minimum screen size that I would guess the application would be viewed on. That way there is never any part of the form that's cut off on the screen.

The other thing you need to check is the "fitToScreen" property. And the way to test if it's relevant to you is to size a form as close to 18" high or 18" wide when you're working on an 18" monitor. Set the prop to YES and make sure the border is sizable, it's moveable (yada yada) and view the form again on a 15" monitor. If you can't see part of it on the 15", then that property doesn't really do what it says it does.