Microsoft KB Archive/105661

= ACC: Form Size Changes Not Retained =

Article ID: 105661

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q105661



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
If you change the size of a form in Design view, and then save and close the form, when you open the form from the Database window, the size of the form will not reflect the changes that you made.



CAUSE
You sized the window that contains the form, not the form itself. A form has its own dimensions, independent of the size of the window that the form is displayed in. This way, the form can be printed correctly no matter what size the window is.



RESOLUTION
There are several methods of changing a form's size, including the following:


 * Set the form's AutoResize property to No. This will cause the Form window to open to the size you set it to, rather than snapping to the size of the form contained within it.
 * Set the form's Width property to the width that you want.
 * Set the form section's Height property to the height that you want for that section.
 * Use the mouse to drag the right side of the form to make the form the width that you want.
 * Use the mouse to drag the bottom of the form or section to make the form or section the height that you want.

Note that you cannot size the width of the form narrower than the reach of the rightmost control on the form. You cannot size the height of a section shorter than the reach of the last control in the section.

NOTE: If you view the form in Form view directly from Design view, the Form window will remain the same size it was in Design view. You can force the Form window to snap to the size of the form by clicking Size To Fit Form on the Window menu when you are viewing the form in Form view.

If you open the form in Form view from the Database window, the Form window will snap to the size of the form automatically.



Steps to Reproduce Behavior

 * 1) Create a new, blank form. Note that the white area of the detail section is 5 inches wide and 1 inch tall.
 * 2) Drag the Form window to make it narrower than 5 inches wide.
 * 3) Save the form with any unique filename, and then close the form.
 * 4) In the Database window, select the form and then choose Open.

The form will open 5 inches wide and 1 inch tall.

