ACC2000: Form Size Changes Not Retained

ID: Q208430

The information in this article applies to:

Microsoft Access 2000

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 for 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 that 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.

MORE INFORMATION

Steps to Reproduce Behavior

Create a new, blank form. Note that the white area of the detail section is 5 inches wide and 1 inch tall.

Drag the Form window to make it narrower than 5 inches wide.

Save the form with any unique name, and then close the form.

In the Database window, select the form and then click Open. The form opens 5 inches wide and 1 inch tall.

REFERENCES

For more information about sizing forms, click Microsoft Access Help on the Help menu, type "size a form to fit its contents." in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: resize prb


Keywords          : kbusage kbdta FmsProp 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 13, 1999