ACC97: Column Changes Not Saved in Datasheet with Tab Control (166363)


The information in this article applies to:

  • Microsoft Access 97
This article was previously published under Q166363
Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

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.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbprb kbui KB166363
©2003 Microsoft Corporation. All rights reserved.