PRB: Size To Fit Form Command Does Not Size Form Properly

Article ID: Q104974
Creation Date: 04-OCT-1993
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0

SYMPTOMS

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

When you choose the Size To Fit Form command to size a window to fit a form based on a table or query, the window does not size to fit the form correctly.

CAUSE

The form's DefaultView property is set to Continuous Forms.

RESOLUTION

Change the form's DefaultView property to Single Form, and then choose the Size To Fit Form command again.

STATUS

This behavior no longer occurs in Microsoft Access for Windows 95 version 7.0.

MORE INFORMATION

Steps to Reproduce Behavior

Open the sample database NWIND.MDB.
Create a new, blank form based on the Categories table.
Create a bound text box based on the Category Name field.
From the View menu, choose Form. Note that the Form window shows several forms.
From the Window menu, choose Size To Fit Form. Note that the window reduces in size, but still displays several forms.

REFERENCES

For more information about Sizing forms, search for "sizing forms," and then "Height, Width Properties" using the Microsoft Access Help menu.

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.