Article ID: 151801 - Last Review: January 19, 2007 - Revision: 2.1

ACC: Field Named "Application" Causes Error

This article was previously published under Q151801
Novice: Requires knowledge of the user interface on single-user computers.

On This Page

Expand all | Collapse all

SYMPTOMS

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:

109312  (http://support.microsoft.com/kb/109312/EN-US/ ) ACC: Reserved Words in Microsoft Access

APPLIES TO
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition
Keywords: 
kberrmsg kbprb kbusage KB151801
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
 

Article Translations