When you switch between Design and Form views, the size of the form is dictated by the size of the Design view window, not the size of the form sections.
You often need to expand the window to be able to see the rulers and scroll bars in addition to all of the sections. This means you're left with wasted space when viewing the form in Form view, assuming that you forget to shrink the window back down.
A solution to this annoyance is to use the Size To Fit Form feature.
Simply view the form in Form view and choose Window>Size To Fit Form from the menu bar. If your view of the form is maximized, the menu option will be unavailable and you'll need to click the Restore Window button on the form window to enable the choice.
Once Access has resized the form, you can save its current dimensions by clicking the Save button.
With Access 2007+ go to the Office button, choose Access Options and click Overlapping Windows. The Size To Fit Form icon will appear on the Home tab.
See all Topics