Microsoft KB Archive/208910

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

Article ID: 208910

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q208910





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:


 * 1) 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
 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  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 kbprb kbusage KB208910

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.