Hello,
I've posted this problem to one other newsgroups, and gotten
some diagnostic help, but I still need a solution. The full text of
the message box is: "The field is too small to accept the amount of
data you attempted to add. Try inserting or pasting less data". This
displays without a run-time error number.
This error comes about when a user (I've been able to reproduce
this error on 2 different workstations; one running
Access2000/Windows2000 and one running Access97/NT4) tries to edit a
9-digit field, defined as such, in the field of the table to which
this control is bound. What is really strange is this:
1) The control (a text box) has no problem containing the data if it's
being displayed and not edited (user has to click a button to edit
data on the form; said button is disabled for users in the
Inquiry-Only group);
2) Another form I have that has the user input data into this form (on
this form, it's intake, so data is ALWAYS being added), has NO trouble
whatsoever with inputting 9 digits; saves it without complaint;
3) I have tried a couple of diagnostic message boxes in BeforeUpdate
for the control that is giving me the problem (on the update form),
and both verify that I am only attempting to input 9 characters.
4) I printed out a KB article for this problem, but it doesn't provide
a solution, as I am not going beyond the number of characters
specified for this field.
Please advise, thanks. F.Barth