|Microsoft Office Access 2003
Microsoft Access 2000 and 2002
You see #Name? displayed in a control.
Access displays #Name? in a control when the name that you supplied as the source of the control's value is not valid. You use the ControlSource property to specify the source of the control's value. For example, you might have misspelled the name, or the source might have been renamed or deleted. You may also see #Name? in a control if you place an expression in the control's ControlSource property and you insert a space before the equal sign that starts the expression.
- Make sure that the field specified in the control's ControlSource property hasn't been removed from the underlying table or record source (record source: The underlying source of data for a form, report, or data access page. In an Access database, it could be a table, query, or SQL statement. In an Access project, it could be a table, view, SQL statement, or stored procedure.).
- Check the spelling of the field name in the control's ControlSource property.
- If you specified an expression (expression: Any combination of mathematical or logical operators, constants, functions, and names of fields, controls, and properties that evaluates to a single value. Expressions can perform calculations, manipulate characters, or test data.) in the control's ControlSource property, make sure that there is an equal sign preceding the expression.
For more information
For additional information regarding specific issues that result in #Name? appearing in a control, see the following Microsoft Knowledge Base articles: