Writing your own code will be long and tedious. There are two excellent products I know of on the market that will do what you want, though the have their limitations.
It called Resizer and it comes packaged as part of their "Total Access Components" package. It sells for 199 and has a lot of other components you might find useful.
The other is called ShrinkerStretcher by Peter De Baets (
Or, you can purchase or get a hold of the code that comes on the CD with the Access 97 Developer's Handbook by Litwin, Getz, Gilbert (SYBEX). I am sure it is also in the 2000 version.
OR (just searched the web) you can go to the following link and download the code from them for free:
I STRONGLY suggest this book... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.