I have database that I would like to distribute. How do I make the forms adjust to differnet monitor sizes?

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

Thanks,

Peter De Baets http://www.peterssoftware.com

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 (http://www.accesswatch.co.uk)