runtime error 2131

[Bob]

Using Access 2000, this message pops up when trying to add a value to a field.

 

[Allen Browne]

In what context are you seeing this error?

Are you in form design view, trying to type something into the Control
Source property of a text box, or what?

 

[Bob]

While running in form view (not design view) we type the first letter in the
first field and the error pops up. I have tried compacting and rebuilding the
database already.

 

[Allen Browne]

Could there actually be an invalid expression in the control source of one
of the calculated controls in the subform?

Could the LinkMasterFields and LinkChildFields properties of the subform
control be set incorrectly? Access will attempt to assign the values from
the main form's fields/controls (named in LinkMasterFields) to the subform's
field/controls (named in LinkChildFields) when you begin adding a record.

If neither of those apply, is the subform based on a query that contains
more than one table? If so, try removing anything in the Default Value of
any controls in the subform, and also remove the Default Value from all
fields in all tables this query is based on. I have seen an error (a
different one) at the precise timing you describe, and traced it back to the
fact that Access was attempting to apply the Default Value to the new record
when the Default Value was set on a field in the lookup table (not the table
the record was being appended to.) Removing the Default Value worked around
the bug.

Hopefully one of those ideas helps.

 

[JamDad]

I ran into this myself - your value must fit the parameters described
in the MS article mentioned below. This is a limitation in Access 2000
that has been corrected with higher versions (02, 03). At the moment,
I just trap it in the error handler, then I keep redusing the size of
my text string that I am trying to attach to the control until it
doesn't error out anymore. That's not the best solution, because I'd
like to see the whole text string, but it gets you past the error.

Here's the link at MS -----
http://support.microsoft.com/default.aspx?scid=kb;en-us;311114


Hope that helps,