Form resize to allow for different screen resolutions

[Tay]

I have some users who are using different screen resolutions to myself. After searching on here, I found some fantastic code which automatically resizes everything to allow for this problem. I have attached a link to the sample db. http://www.anauz.clara.net/access.htm

On one thread I discovered (and that contains the link), there were around 100 requests for it, so I am assuming that quite a few people have seen/used it.

I do have a couple of problems with it though - it is refusing to resize tab controls in subforms, and it also goes mad when I try to open one form which contains 5 subforms. This happens when I reduce my screen resolution. I get error messages appearing saying that 'the control or subform control is too large for this location etc.'

There is too much code to post here, so I am just hoping that some of you may remember or have used the code, and if any of you encountered any problems similar to mine, I'd be grateful if you could let me know how you resolved them.

TIA.

PS. Here is the thread where I found the code.
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=19648&highlight=resize+screen

 

[Hayley Baxter]

Hi Tay

I have experienced the very same problem as you with my subfrm not so long ago. I had a thread on it too

Here is the thread

http://www.access-programmers.co.uk...id=6845&highlight=too+large+for+this+location

I resolved it by playing around with it making the design of my subfrm smaller until I got some joy with it.

Hay

 

[Tay]

Cheers Hayley

At least I know I'm not the only one. It also affects subforms in datasheet view, which is a real pain. Guess I'll just have to redesign a few things.

Thanks

Tay

 

[Peter D]

There are third-party form scaling solutions available that might help to resolve some of the issues you are having:

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=0782119417/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

 

[Tay]

Thanks for the help so far.
The problems I am encountering can largley be overcome, but I am still having trouble with one aspect - subforms which contain tab controls. What is happening is nothing - the tab control stays the same size as what it was developed at. Font size is the same, and controls on the tab control are being cut off.
If anyone has had this problem and overcome it, please could you give me an idea as to how to get round it?
Thanks.

 

[Autoeng]

Is the data in the subform in datasheet view? I have yet to find any resizer that can resize datasheet views. If not I have had great success with the resizer at www.developershandbook.com\default.asp. You might try it to see if you get the results that you want. Be forewarned to diable the resizer when working on your forms in design mode though as you can get unexpected sizes when you save.

Autoeng

 

[Tay]

One of my problems is with datasheet view, although that doesn't trouble me greatly. My main problem was with tabbed controls in a subform and that neither would resize. However, I think I know why this is. I have a main form with a subform control in the centre. In the subform control, a number of different subforms appear depending upon the value of a control on my main form. Therefore, my subform control has no source object.
Which leads me to more despair....