Why don't you try this one, and let me/us know if it worked for you.
I haven't had time to test it out, but it looks pretty slick. http://knk.homepage.com/ReSizeForm.htm
You could try writing this yourself but it is very time consiming and prone to error, it also requires a number of API calls outside Access so the chances of problesm occuuring on your users machines increases.
If you want to try and do it yourself then the "Access 97 Developers Handbook" from SYBEX has a very good chapeter on how to do this.
The alternative to this is to usea third party product.
I use FMS total Access Components which includes both a splitter and resizing component (plus 25 other compnents). You can find this at http://www.fmsinc.com/products/components/Components2000/ControlTour/resize.htm.
I can recommend these compnonents but you do need to purchase all 27 components.
I have not tried this so do not know how it performs, if anyone has used this I would be interested in your comments.
Hope this helps
Regards
Trevor from www.accesswatch.co.uk
I have tried both of those sites.
One is too expensive or shareware and the
other doesnt work that great. If you like
i have an easy fix. Email me for the code
mailto:Rjohnstone1@home.com
I appreciate you have designed the entire database but is it not possible at this time to create copies of the original forms linking to your tables and just downsize the actual forms by the changing of font sizes / design modification.
It may then just be a case of allowing a user to choose which form they wish to view from a front end. Alternatively their may even be a piece of code that identifies the resolution and chooses accordingly.