Web Development

General discussion


Access 97: Form size

By pcarter ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 97: Form size

by DKlippert In reply to Access 97: Form size

Save in Design view, set Pop up to yes.

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


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

There is a third party add-in called ShrinkerStretcher:


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

Collapse -

Access 97: Form size

by pcarter In reply to Access 97: Form size

Putting DoCmd.Restore in the Form_Activate() event doesn't help.

Related Discussions

Related Forums