ACC2000: "#Error" Message in Table Field or Form Control

ID: Q208910

The information in this article applies to:

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you move to a new record in a table or on a form, you may note that the field or control contains:

#Error


CAUSE

This error occurs if one of the fields in the record has a default value that exceeds that field's FieldSize property setting.


RESOLUTION

Increase the field's FieldSize property setting to be equal to or larger than the field's default value. Or, change the field's default value so that it does not exceed the field's FieldSize property setting.


MORE INFORMATION

A "#Error" message is displayed in the field whose default value exceeds its FieldSize property setting. Access will prevent the user from exceeding the maximum number of characters determined by the FieldSize property setting.

Steps to Reproduce Behavior

  1. Start Microsoft Access and open any database.


  2. Create and save the following new table:


    3. 
   Table: tblTest
   -------------------------
   Field Name: lngID
   Data Type: AutoNumber
      
   Field Name: txtOne
   Data Type: Text
   FieldSize: 5
   DefaultValue: Too Long
     
   Field Name: txtTwo
   Data Type: Text
  3. Open the table, tblTest, in Datasheet view. Note that each new record shows "#Error" in field, txtOne.


Additional query words: data entry prb 


Keywords          : kberrmsg kbusage kbdta GnlDe 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 13, 1999