Microsoft KB Archive/106302

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:13, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q106302 to Microsoft KB Archive/106302 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

PRB: Datasheet Fields Ignore Show or Hide Settings

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

1.00 1.10 WINDOWS

The information in this article applies to:
- Microsoft Access versions 1.0 and 1.1 - Microsoft Access Distribution Kit version 1.1


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.


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


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.