|
(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.
|
