Microsoft KB Archive/44671

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Microsoft Knowledge Base

File: #ERROR! Is Displayed in Computed Field

Last reviewed: October 27, 1994
Article ID: Q44671

Summary:

If #ERROR! is displayed in a Microsoft File computed field, something is wrong with the formula that defines the computed field. The following are three possible causes of this problem:

  1. The formula refers to a Text, Memo, or Picture field. Number and Date fields are the only field types that can be referred to in the formula of a computed field.
  2. An arithmetic/numeric operator has been used in the field name. Symbols such as "+", "-", "/", "*", and "$" used as part of a field name may cause the computed field to return an error. These symbols are being read as operators of the calculation, not as part of the field name. Therefore, the field name will be read as a text string, not one of the field names for the data file.
  3. A field name referred to by the computed formula starts or ends with a number with a space between the number and other characters in the name (e.g. "17 Jan" or "Jan 17"). The number will be read as a number to be calculated by the computed formula. Therefore, the rest of the characters in the filed name will be read as text, not as one of the field names for the data file.
  4. One of the field names used in the formula is misspelled. In this case, File will not recognize the field name.

To correct the problem, do the following:

  1. Highlight the computed field in the form.
  2. From the Form menu, choose Format Field.
  3. Correct the formula at the bottom of the dialog box.

Additional reference words:

KBCategory: kbusage kbprb
KBSubcategory:


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 27, 1994
©1997 Microsoft Corporation. All rights reserved. Legal Notices.