ACC97: Column Changes Not Saved in Datasheet with Tab Control

 Last reviewed: May 21, 1997
Article ID: Q166363
The information in this article applies to:
  • Microsoft Access 97

SYMPTOMS

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

When you make changes to the column width of a control in Datasheet view of a form that has a Tab control, the changes are not saved when you close the form.

CAUSE

When you place the controls that make up a datasheet on a Tab control instead of on the form itself, you will not be able to save changes made to the structure of the datasheet.

RESOLUTION

Place all controls for which you are going to modify the column width on the form instead of on the Tab control.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb and create a new form based on the Categories table.

  2. Place a Tab control on the form and drag a few fields from the field list to the Tab control.

  3. Set the ViewsAllowed and DefaultView properties of the form to Datasheet. Switch the form to Datasheet view.

  4. In Datasheet view, change the column width of a few columns, and then close and save the form.

  5. Reopen the form. Note that the column widths of the fields that you modified have changed back to their original sizes.

REFERENCES

For more information about using the Tab control, search the Help Index for "tab controls, overview," or ask the Microsoft Access 97 Office Assistant.

Keywords : kbui UifDatash
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: May 21, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.