Microsoft KB Archive/160952

= ACC: Unhide Columns Unavailable on Subform in Datasheet View =

Article ID: 160952

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q160952



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



SYMPTOMS
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



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.

