Microsoft KB Archive/106302

PRB: Datasheet Fields Ignore Show or Hide Settings

PSS ID Number: Q106302 Article last modified on 11-05-1993

1.00 1.10 WINDOWS

= SYMPTOMS =

When you are viewing a form in Datasheet view, fields will ignore the show or hide setting you have chosen. Instead, the setting for the field’s Visible property will control whether the field shows or is hidden. In other words, if you set a field’s Visible property to No (which makes the field invisible), then attempt to show the field by choosing Show Columns from the Layout menu, the setting is ignored and the field remains invisible.

= CAUSE =

This behavior is by design. The Datasheet view’s show or hide setting is independent of the Form view’s Visible property setting.

= MORE INFORMATION =

Steps to Reproduce Behavior

 * 1) Start Microsoft Access and create a new database.
 * 2) Create a new form (Form1) and place two text box controls on it (Field0 and Field2).
 * 3) Set the Visible property of the second text box (Field2) to No.
 * 4) View the form in Form view. Note that Field2 is not visible.
 * 5) View the form in Datasheet view.
 * 6) From the Layout menu, choose Show Columns, and show Field2. Note that the Field2 column appears in the datasheet.
 * 7) View the form in Form view. Note that the second text box control (Field2) is still hidden.

Additional reference words: 1.00 1.10 Forms Hiding KBCategory: KBSubcategory: TblFldprop Copyright Microsoft Corporation 1993.