ACC: Unhide Columns Unavailable on Subform in Datasheet View

Last reviewed: May 30, 1997
Article ID: Q160952
The information in this article applies to:
  • 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.


Additional query words: reveal show conceal gray grey
Keywords : FmsHowto FmsSubf
Version : 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.