ACC97: New Datasheet AutoForm Uses Style of Last Created Form

 Last reviewed: July 14, 1997
Article ID: Q168873
The information in this article applies to:
  • Microsoft Access 97

SYMPTOMS

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

When you create a new Datasheet form using the AutoForm: Datasheet Wizard, the background of the form in Design view is different from what you expect.

CAUSE

The AutoForm Wizards always default to the last style used when you created a form using the Form Wizard (or the last style you selected in the AutoFormat dialog box). This includes the AutoForm: Datasheet Wizard. This will not affect how the form will appear in Datasheet view.

RESOLUTION

If you want to have your form displayed in a different style, in Design view of the form, modify the style by clicking AutoFormat on the Format menu, and then changing the style in the AutoFormat dialog box.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.

  2. Using the AutoForm: Datasheet Wizard, create a new form based on the Customers table.

  3. View the resulting form in Design view.

    The background of the form will be the same background you used the last time you created a form using the Form Wizard.

REFERENCES

For more information about using the Form wizards, search the Help Index for "Form wizard," or ask the Microsoft Access 97 Office Assistant.

Keywords : FmsWiza kbui
Version : 97
Platform : WINDOWS
Hardware : x86
Issue type : kbprb
Resolution Type : Info_Provided

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.

Last reviewed: July 14, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.