Microsoft KB Archive/92683

From BetaArchive Wiki
Knowledge Base

ACC: "#Name?" or Control Is Blank on Form Based on a Query

Article ID: 92683

Article Last Modified on 1/18/2007


  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition

This article was previously published under Q92683

Moderate: Requires basic macro, coding, and interoperability skills.


If you have a form that is based on a query, and the query contains multiple fields with the same name (such as FieldA from Table1, and FieldA from Table2), the control(s) on the form that are bound to that field name will be blank or may display the "#Name?" error.


Because the same field name appears multiple times in the query that the form is based on, Microsoft Access does not know which field to link to the control(s). Therefore, instead of making an assumption about which field to bind to, it leaves the control(s) linked to duplicate field names blank or displays the "#Name?" error in the control.


To correct this behavior, rename the field in the query.

To change a field name in a query, follow these steps:

  1. In a query's Design view, place the insertion point in front of the first letter of the field name in the query design grid.
  2. Type the new name followed by a colon. Delete any names assigned by Microsoft Access, but do not delete the field name or expression.

NOTE: If you change a field name in a query's Design view, it changes the heading in the query's Datasheet view and the field name in a form or report based on the query. However, the underlying field name in the table does not change.


For more information about changing a field name in a query, search the Help Index for "query design grid," or ask the Microsoft Access 97 Office Assistant.

Additional query words: poundname

Keywords: kberrmsg kbprb KB92683