ACC: Field Named "Application" Causes Error

Last reviewed: May 12, 1997
Article ID: Q151801
The information in this article applies to:
  • Microsoft Access versions 2.0, 7.0, 97

SYMPTOMS

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

If you try to preview a report that contains a bound field whose ControlSource property is set to a field named Application, you may receive the following error message:

In Microsoft Access 7.0 and 97

   Microsoft Access can't find the field 'Application' referred to in
   your expression.

In Microsoft Access 2.0

   Invalid Reference to field 'Application'

NOTE: If you use the AutoReport tool in version 2.0, you first receive the following message:

   The Wizard can't display your report in Print Preview. It will be
   opened in Design view.

RESOLUTION

Change the name of the field in your table to something other than "Application."

MORE INFORMATION

Steps to Reproduce Behavior

In Microsoft Access 7.0 and 97

  1. Create a new table and add a text field named Application. Close and save the table as tblTestField.

  2. Create a new report based on the tblTestField table, and select the AutoReport: Columnar Wizard.

  3. When you receive the first message, click OK. On the File menu, click Print Preview. Note that you receive the error message described in the "Symptoms" section.

In Microsoft Access 2.0

  1. Create a new table and add a text field named Application. Close and save the table as tblTestField.

  2. Create a new report based on the tblTestField table and click Report Wizards. Select AutoReport, and then click OK.

  3. When you receive the first message, click OK. On the File menu, click Print Preview. Note that you receive the error message described in the "Symptoms" section.

REFERENCES

For more information about reserved words, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q109312
   TITLE     : ACC: Reserved Words in Microsoft Access
 

	
	


Keywords : GnlOthr kberrmsg kbusage
Version : 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided


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.

Last reviewed: May 12, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.