INF: DisplayWhen Does Not Affect Fields in Datasheet View

Article ID: Q132001
Creation Date: 26-JUN-1995
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access version 2.0

SUMMARY

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

The "Description" section of the "DisplayWhen Property" topic in the Microsoft Access Help system reads as follows:

   Determines whether an object is displayed or printed.

This information is misleading because it does not mention that the DisplayWhen property affects the form in Form view only and not in Datasheet view.

RESOLUTION

The "Description" section of the "DisplayWhen Property" topic in the Microsoft Access Help system should read as follows:

   Determines whether an object is printed or displayed in Form view.

NOTE: To specify whether a field is visible in Datasheet view, use the ColumnHidden property.

REFERENCES

For more information about the DisplayWhen property, search for "DisplayWhen," and then "DisplayWhen Property" using the Microsoft Access Help menu.

For more information about the ColumnHidden property, search for "ColumnHidden," and then "ColumnHidden Property" using the Microsoft Access Help menu.

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.