Resize Screen

[Hayley Baxter]

I am designing a db on a 14 screen while the users I am designing it for have 17 screens. I know there is a way to resize forms so that it automatically adjusts to fit other sizes of screens but I do not have a clue how to do this.

Can anyone give me some advice or point me in the right direction?

Many thanks

 

[David R]

Search the Forms forum for "resize" and you'll get scores of answers. Good luck.

David R

 

[Peter D]

You can use a third-party form rescaling module or add-in to resize your forms for you, or write the code yourself, but it is quite involved.

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

 

[Hayley Baxter]

Thank you for your help I have managed to get this working now. Only problem is on the smaller screens my text is all crammed it can hardly be seen.

Is there a way round this?

Many thanks

 

[Peter D]

I might need more information in order to help you out. Which form resizing solution did you implement? If you are using ShrinkerStretcher, there is a minimum font size constant that will keep fonts from resizing to very small, un-readable sizes.

Also, sometimes a form has empty space to the right, or below the area where controls are present. Form resizing tools will often resize this empty space along with the rest of the controls, producing extremely small controls, and unreadable fonts. The solution in this case is to go into form design mode and remove the empty form space.

Hope this helps,

Peter De Baets
Peter's Software - http://www.peterssoftware.com

 

[Hayley Baxter]

I used the following link:
http://www.anauz.clara.net/access.htm

Users with 17inch screens can see all the data clearly while users with 14 inch screens can see all the data but not clearly. The text is just so small. In another topic on this forum called Forms Resizing it has been mentioned that the font type must be set to true. I always had a font type that was true but it doesn't look good at all.

Anyone who knows of a way to resolve this I would love to hear from you.

Thank you in advance
Hayley

 

[Rich]

The trick is to use the smallest screen/resolution possible to develop the db and then re-size for larger resolutions.

 

[Hayley Baxter]

I am developing the db on the one of the smallest screens concerned. When I did this I didnt like the fact that my text boxes, subform etc were all at the top left hand corner of the larger screen. I wanted the db to put the subform at the bottom for the larger screens.

Can I do this?

[This message has been edited by Hayley Baxter (edited 01-03-2002).]

 

[Hayley Baxter]

Im still stuck with this one. If I use the code to resize my form the text is too small on the 14/15inch screens, on the 17 they are perfect. If I dont use the code its perfect on the small screens but boy does it look messy on the 17 inch screens. I'm convinced there must be a way to make the text on my smaller resolution screens bigger. The db is stored on a shared drive for all the users and I have 3 different resolution sizes here and cant please everyone. It simply is not professional.

Can anyone who has used this function offer me any further advice?

Many thanks to everyone for their assistance

 

[Peter D]

Well, first of all, it's not the size of the screen, it is the display resolution that is causing your forms to appear bigger, or smaller on the different computers.

Is changing your users' screen resolutions an option? Try right clicking on the desktop, then go to properties > settings to change the screen resolution.

Next, what size are your fonts? If you are starting with 8 point fonts, then scaling from a 1024x768 monitor down to an 800x600 monitor, you are going to wind up with 5 or 6 point fonts which are very hard to read. If you start with 10 point fonts at 1024x768, you'll have better results at 800x600.

Third, check for empty form space in form design mode. This can cause un-expected over-scaling in some situations.

Hope this helps,

Peter De Baets
Peter's Software - http://www.peterssoftware.com

 

[Rich]

You posted a question a few days ago with a statement that looked something like this:
Call adhScaleForm(Me, 800, 581, 96, 96, rctOriginal)
I can't find it now so post the exact statement that you are using and also the resolution of your pc from the control panel.

 

[Hayley Baxter]

Peter - Thank you for drawing the real problem to my attention. It appears your spot on with the resolution of my pc (800 by 600) and I am also using 8 size fonts on the larger resolution screen. I am going to have a go at this later and I'll let you know how it goes.

Rich - The statement I used was this:

Call adhScaleForm(Me, 1152, 817, 96, 96,rctOriginal)

My screen resolution is 800 by 600

 

[Rich]

If the screen resolution you developed the db on is 800 x 600 then your statement is wrong: use
Call adhScaleForm(Me, 800, 581, 96, 96, rctOriginal)

 

[Hayley Baxter]

Rich thats's fantastic thank you so much and thanks to everyone else as well you've all been great!

Can I just ask for future reference as Im not too good with vb code where does this statement come in, I am assuming the 800 part is referring to the 800 by 600 resolution but where does the rest come from - how do I establish what numbers to use depensing on resolution?

[This message has been edited by Hayley Baxter (edited 01-04-2002).]

 

[Anauz]

Hayley

The statement determines your development
resolution. As you have worked out now
Call adhScaleForm(Me, 800, 581, 96, 96, rctOriginal) means you are working on 800x600
resoultion. I may have missed a step in my readme note, what you need to have done was run form frmScreenInfo in the resoultion you are developing. This will set your base settings and would either scale up or down from this. the 96,96 is the x,y co-ordinates of your form.