473,243 Members | 1,522 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,243 software developers and data experts.

"The field is too small to accept ..." error for a bound control on a form

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
Nov 12 '05 #1
5 10166
What number was the kb article?

The field you refer to that contains a 9-digit number: what is the data type
of the field? Text or Number? And what is the Field Size (lower pane in
table design view)?

It may be possible to trap this error in the Form_Error event. However,
that's not going to tell you much more than you already know.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"F. Barth" <Is*******@hotmail.com> wrote in message
news:6b**************************@posting.google.c om...
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

Nov 12 '05 #2

"F. Barth" <Is*******@hotmail.com> wrote in message
news:6b**************************@posting.google.c om...
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

Nov 12 '05 #3
I've run into this problem before -
getting that diagnostic message when it turned out that something quite
different was actually the problem.
Wish my memory were better!!
First thing I'd guess would be corruption -
are you familiar with ways to address that?

= Turtle

"F. Barth" <Is*******@hotmail.com> wrote in message
news:6b**************************@posting.google.c om...
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

Nov 12 '05 #4
The KB article was 121512. The specific problem I have with it is
that it says that the error is caused if one field in a record has a
default value that is too large for the field's size. However, my
users are able to change other fields using that same (update) form.
This error has only been reported on one field. So if there was a
problem with a default value on another field, then this error would
be occurring much more frequently.
The field in question is defined as Text, 9.
F. Barth
Nov 12 '05 #5
Okay. The k.b. does not apply, and you are fairly certain which field causes
the problem, because you can create the problem by editing *only* this field
on your form.

Is there anything in the Format or Input Mask properties of the text box
that could be masking what is really there? Or a Validation Rule? Anything
in the BeforeUpdate or AfterUpdate events of the text box?

While the text box has been edited and the record cannot be saved, are you
able to move focus to another text box? If so, open the Immediate window
(Ctrl+G) and ask Access how long the field is. Something like this:
? Len(Forms![Form1]![Text1])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"F. Barth" <Is*******@hotmail.com> wrote in message
news:6b**************************@posting.google.c om...
The KB article was 121512. The specific problem I have with it is
that it says that the error is caused if one field in a record has a
default value that is too large for the field's size. However, my
users are able to change other fields using that same (update) form.
This error has only been reported on one field. So if there was a
problem with a default value on another field, then this error would
be occurring much more frequently.
The field in question is defined as Text, 9.
F. Barth

Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Mark | last post by:
Hi, I'm running visual studio 2003, and am now receiving the error "The Operation Could Not Be Completed" when attempting to add a form / control or component class to a project. I can add any...
6
by: TS | last post by:
Hi, i have a problem validating xml against schema. I used http://apps.gotdotnet.com/xmltools/xsdvalidator/Default.aspx validator and it says it is fine. Can you tell me why this doesn't work? ...
1
by: RWC | last post by:
Hello, I'm getting the error "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data" when I run a report. I'm simply trying to apply the...
12
by: Yarco | last post by:
when doing fork in a loop: while(1) { tmp_sd = accept(sd, (struct sockaddr*)&tmp_sin, &len); if (tmp_sd == -1) { perror("accept"); exit(0); } //check client ip
8
by: Lars-Erik Aabech | last post by:
Hi! We've got an ASP.NET application that runs swell on development PC's and one live production server. Another prod. server though crashes a couple of times a week. Either something that...
0
by: davidr | last post by:
Hi, I have a panel that I load user Control in no problem. The problem arrises when I do a post back on one of these user controls. I have button it does a click event. In this click event I...
7
by: PW | last post by:
Hi, I have a form with unbound fields on it. The user selects a record from a recordset and I populate the unbound fields. When I try to change the unbound quantity text box, Access 2003 tells...
9
by: Ecohouse | last post by:
I have a main form with two subforms. The first subform has the child link to the main form identity key. subform1 - Master Field: SK Child Field: TrainingMasterSK The second subform has a...
10
by: Roger | last post by:
ms-access97 & sql server2005 two tables tblItem tblItemFeature form frmItem contains subform frmItemFeature each form is based on their respective table creating new record and filling in...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.