Have designed an entire database using a 19" monitor. Please advise best way for laptop and other small monitor users to view the forms, reports, etc.

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

Michael Abrams

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.

Another Alternative is
Peter's ShrinkerStrecher for Access at http://www.peterssoftware.com/ss.htm

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 (http://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.

No flames please

Regards

Ade

Try the form resizer at www.developershandbook.com under downloads. Works great and free.