ACC: Unhide Columns Unavailable on Subform in Datasheet View

• Microsoft Access versions 7.0, 97

SYMPTOMS

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

When you open a form containing a subform that displays in Datasheet view, you can hide columns on the subform by clicking Hide Columns on the Format menu; however, you cannot unhide any columns because Unhide Columns is always dimmed on the Format menu.

RESOLUTION

Use one of the following three methods to unhide the columns.

Method 1

1. Open the form containing the subform with hidden columns.

2. On the subform, point to the left edge of the column heading that is immediately to the right of the column you want to unhide. The pointer becomes a cross with arrows that point left and right.

3. Double-click while the pointer resembles a cross with left and right arrows, and the hidden column appears. Drag the column border to the desired width.

Method 2

1. Open the subform by itself in Datasheet view.

2. On the Format menu, click Unhide Columns.

3. Click the columns you want to unhide.

4. Close the subform.

5. Open the main form and note that the subform columns are no longer hidden.

Method 3

You can unhide the column programmatically by setting the ColumnHidden property to False for the hidden control on the subform, as in this code sample:

   Forms!Orders![Orders Subform].Form![ProductID].ColumnHidden = False

MORE INFORMATION

Steps to Reproduce Behavior

1. Open the sample database Northwind.mdb.

2. Open the Orders form in Form view.

3. Place the insertion point in the Product field.

4. On the Format menu, click Hide Columns. Note that the Product field disappears.

5. Click the Format menu, and note that Unhide Columns is dimmed.

REFERENCES

For more information about hiding columns, search the Help Index for "hiding columns, datasheets," or ask the Microsoft Access 97 Office Assistant.