It is possible to code this yourself although it gets very complicated. If you are interested then the 'Access 97 Developer's Handbook'from SYBEX has a whole chapter devoted to this subject. My advice is don't even attempt to do it unless you have a lot of time to spare.
A better solution to use a 3rd Party add on
such as the FMS Sizer Splitter tool. You can find details about this at http://www.fmsinc.com
I believe there are a number of shareware tools about to handle this. I think one is called 'resizer' and another is called 'SizerSplitter'. Hopefully someone on the forum can point you to a site where these can be found.
Hope this helps
Trevor from Accesswatch.co.uk
Another form rescaling module (which I wrote) is called ShrinkerStretcher. A shareware/demo is available for download from: http://www.peterssoftware.com/ss.htm
You turned up a day late Peter I have just spent the evening trying to locate your program but as I forgot the name It took some time. I'm glad I found it though because I like the look of your other program 'Data Flow manager' which might be just the thing I have been looking for, I'll be trialing it asap. Anyway 'SizerSplitter' sounds close to 'ShrinkerStretcher' Sorry if I mislead anyone with the wrong name.
Regards
Trevor from www.accesswatch.co.uk