Home  |   French  |   About  |   Search  | mvps.org  

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

In Memoriam

Terms of Use


VB Petition

Forms: Resolve #Name error in a form/report

Author(s)
Dev Ashish

(Q)    Why do I get a #NAME error for a calculated control on a form or a report?

(A)    You are probably using the same name for a calculated text box as one of the terms in the expression. In the following example, Access produces a #NAME error if you enter the expression in a control named City, State, or ZIP:


=[City] & "", "" & [State] & "" "" & [ZIP]

This creates a circular reference that may be resolved by changing the name of the control that contains this expression to something (anything) other than City, State, or ZIP.


1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer