PRA: Cannot Delete Query Caption Property

Article ID: Q117170
Creation Date: 22-JUN-1994
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access version 2.0

SYMPTOMS

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

You cannot delete a field's caption in a query after you save the query. The caption is displayed the next time you open or run the query, even though you deleted it. This problem only occurs when you are trying to set the field's caption back to its original blank state.

RESOLUTION

To work around this problem, re-create the query, or set the field's caption to some other text.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs in Microsoft Access for Windows 95 version 7.0

MORE INFORMATION

Steps to Reproduce Problem

 1. Open the sample database NWIND.MDB.

 2. Open the Quarterly Orders By Product (Crosstab) query in Design view.

 3. Change the Product Name field's Caption property to "My Caption"
    (without the quotation marks). To see the field's property sheet, click
    in the Product Name field in the query grid, and then click the
    Properties button on the toolbar.

 4. Run the query. Verify that "My Caption" appears as the caption for the
    Product Name field.

 5. Save and then close the query.

 6. Reopen the query in Design view.

 7. Delete the caption for the Product Name field.

 8. Run the query. Note that the caption has changed back to "Product
    Name."

 9. Save and then close the query.

Run the query again. Note that the caption is still set to "My
    Caption."

REFERENCES

Microsoft Access "User's Guide," version 2.0, Chapter 10, "Query Basics," pages 219-221

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.