Knowledge Base

ACC97: Column Changes Not Saved in Datasheet with Tab Control

Article ID: 166363

Article Last Modified on 1/19/2007

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.

MORE INFORMATION

Steps to Reproduce Behavior

Open the sample database Northwind.mdb and create a new form based on the Categories table.
Place a Tab control on the form and drag a few fields from the field list to the Tab control.
Set the ViewsAllowed and DefaultView properties of the form to Datasheet. Switch the form to Datasheet view.
In Datasheet view, change the column width of a few columns, and then close and save the form.
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: kbprb kbui KB166363