Discussion Locked

Access 97: Form size

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do I get a form to display with the size that is set in design view? I have created a form that is 5 inches wide and 3 inches high. I would like it to display at exactly that size. However, double-clicking on its icon or opening it in code causes it to fill the entire screen or (if its Pop-up is set to True) to display about 9 inches wide and 6 inches high. What's the trick to get it to display as designed?

2 replies

by dklippert

Save in Design view, set Pop up to yes.

In the Activate Event for the form, add this code:

DoCmd.Restore

This will restore the forms intended/designed size and location.

There is a third party add-in called ShrinkerStretcher:

www.peterssoftware.com/

There is, also, some code on the CD that comes with the Access 97 Developer's Handbook (ISBN: 0-7821-1941-7) by Litwin, Getz and Gilbert. There is a discussion starting on page 465

This discussion is closed to new replies.