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

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

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

Start Microsoft Access and open any database.

Create and save the following new table:

   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