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
---------------------------------------------------------------------

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.