Microsoft KB Archive/166363

= ACC97: Column Changes Not Saved in Datasheet with Tab Control =

Article ID: 166363

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



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.



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.

