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 5 10191
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*******@hotm ail.com> wrote in message
news:6b******** *************** ***@posting.goo gle.com... 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
"F. Barth" <Is*******@hotm ail.com> wrote in message
news:6b******** *************** ***@posting.goo gle.com... 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
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*******@hotm ail.com> wrote in message
news:6b******** *************** ***@posting.goo gle.com... 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
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
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*******@hotm ail.com> wrote in message
news:6b******** *************** ***@posting.goo gle.com... 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 other type of item without a
problem.
This is the second time this has happened to my machine, last time I
reinstalled VS and it fixed it.
I havent...
|
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?
Thanks!
Schema:
<?xml version="1.0"?>
<xs:schema id="ReportInfo" targetNamespace="http://tempuri.org/Reports.xsd"
|
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 following criteria/filter to this
report "kEmployee in(select kEmployee from proCriteria;)" I'm not really
trying to insert any data. This same...
|
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
|
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 should be bound reports that column X
isn't found, or that the IListSource does not contain any datasources. We
get the solution up again by restarting...
| |
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 will do some
database updates, then I will use reflection to call a method in the
parent (this.page) to load the new user control. Its at this...
|
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 me "The data
has been changed. Another user edited this record and saved the
changes before you attempted to save your changes. Re-edit the...
|
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 master-child link to the first subform.
subform2 - Master Field: subTrainingModule.Form!TrainingModuleTopicSK
Child Field: TrainingModuleTopicSK
|
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 two bound fields works fine
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |