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

mail this guy:
rdhicks@mindspring.com
he gave me the solution to the exact same problem yesterday, I just dont have a saved copy to send.

Check your email, I had to change a couple of lines of code to do the 1024x768 thing.

Good Luck
RDH

I could also use this code.
could someone send it to me at:

Fdarouian@yahoo.com

thanks

Could someone e-mail me this code too.

kstroupe@phsystems.com

Thx

could you just post it instead!!!
thanks Mr Hicks, I've done some code to do this myself but am less than convinced that it's the best way and could *definitely* use a better version

many thanks RDH

Drew

[This message has been edited by KDg (edited 02-29-2000).]

I don't think that just posting the code will tell the whole story. Certain events have to run on open, and certain events have to run on close, and also it involves a hidden form that retains the opening resolution so the it can be set back to the original resolution upon exiting the program.

I am going to place the database and a text file, with instructions on a FTP site so anyone who wants it can download it. As soon as it's posted I'll let everyone know where it is.

RDH

[This message has been edited by R. Hicks (edited 03-03-2000).]

Many thanks, I look forward to it

Drew

Hi.

Could I please have a copy of the code too?

Also I would like to know how to "center" a "dialog form" so that it does not appear in the corner.

Thanks


Ur.

[This message has been edited by ursidae (edited 04-01-2000).]

[This message has been edited by ursidae (edited 04-01-2000).]

Hi,

To resize forms is not real simple. Here is a site with the code for Access 97. It works with a few small changes with 2000. The persons that wrote the code have a 2000 version available on a disk in their Access 2000 book. Good Luck, and it does work.
http://www.mvps.org/access/general/gen0002.htm

Warren
04-01-00
22:05:34 PST

Has anyone had any luck doing this. I am trying to find some code, but have had no luck yet.

You can use a third-party form rescaling module or add-in to do this for you, or write the code yourself (because of the complexity, this is not recommended).

A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss.htm

There's a great article about form scaling in this month's SmartAccess newsletter. Check it out here; http://www.smartaccessnewsletter.com

Also, more info is linked here: http://www.mvps.org/access/general/gen0002.htm

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com