Microsoft KB Archive/168873

From BetaArchive Wiki

Article ID: 168873

Article Last Modified on 1/19/2007


  • Microsoft Access 97 Standard Edition

This article was previously published under Q168873

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.


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.


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.


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.


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

Keywords: kbprb kbui KB168873