size & screen position of forms

[diversoln]

I've been working with forms for a while now and haven't been able to solve the problem of having them resize and shift around the screen when I go from the design view to the form view. I've tried a number of options in the properties but nothing seems to work. Typically what happens is I try to make the form fill the screen in the design view but in the form view its shifted out of position - sometimes to the left & down, sometimes to the right & up, cropping some of the form. There doesn't seem to be any pattern to how it will appear.

Also - I've heard that when the database is deployed on other machines with different screen sizes or maybe numbers of pixels, the forms will look different - is this true, what work arounds are there so my forms will look nice on any machine ? Thanks.

 

[Rich]

Simply drag the form to the position you want in form view and press save, resizing when using different resolutions requires complex code and it's far form perfect, sadly.
HTH

 

[russi]

Hi. I have something that handles screen resolution (and thus form size as it appears on screen).
E-mail for sample.

Russ

 

[Rich]

Russi how does your code cope with page breaks and tabbed subforms?

 

[Peter D]

Here are some form rescaling solutions:

A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss.htm

FMS has a sizer module at www.fmsinc.com.

The Access Developer's Handbook has form resizing code included: http://www.amazon.com/exec/obidos/ISBN%3D0782119417/107-8064361-7403703

For more informmation, there are some great articles about form scaling in the December 2000, and May 2001 SmartAccess newsletter. Check it out here: http://www.smartaccessnewsletter.com

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com

 

[russi]

Rich,

First, the code is not of my creation and I simply use it (with success, I might add).


Page breaks are no problem and subforms are okay but I have not used tab-subforms.

What this does is change the user's screen resolution upon opening the database. You can modify the code to match the resolution you created the form in. This way, things look as they should.

There IS one caveat though. If the user hasa different Windows Default Font Size chosen (in the Control Panel) it will not change that. So all I do is have the user 'permanently change this font size'. BUt they get to keep their favorite resolution except when running the Access application.

Russ

 

[diversoln]

This is great advice - thanks!!!