Article ID: 121512
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Access 1.0 Standard Edition
- Microsoft Access 1.1 Standard Edition
- Microsoft Access 2.0 Standard Edition
- Microsoft Access 95 Standard Edition
- Microsoft Access 97 Standard Edition
This article was previously published under Q121512
Novice: Requires knowledge of the user interface on single-user computers.
SYMPTOMS
When you enter data in a new record on a form or in a table, you may receive the following error message:
In Microsoft Access 97:
In Microsoft Access 7.0:
In Microsoft Access 2.0:
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
You do not receive the error message until you enter data in a record because the record is not marked for saving to the table until you make some change to the record.
This error will also cause a "#Error" message to be displayed in the field whose default value exceeds its FieldSize property setting.
Steps to Reproduce Behavior
- Start Microsoft Access and open any database.
Create and then save the following new table:
Table: Too Long ------------------------- Field Name: One Data Type: Text FieldSize: 5 DefaultValue: Too Long Field Name: Two Data Type: Text
- Create a form based on the Too Long table.
- View the form in Form view, and type any data in the Two field. Note that you receive the error message mentioned in the "Symptoms" section.
Additional query words: data entry couldn t
Keywords: kberrmsg kbprb kbusage KB121512