Access97: "The field is too small to accept ..."

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I posted on this awhile ago, and never got a solution. This issue is discussed in KB article 121512, but its proposed solutions don't work for my situation (see #2 below). I have done the following to try to resolve it already
1- used message box to show the number of characters I was trying to use for that field (was 9, which is the size of that field in the table to which the form is bound
2- Have been able to edit this field successfully directly into the table - and a different form where new records are entered is able to accept the 9 characters for this field (the problem occurs on a modify-existing-data form
3-On a development copy of the database, I have tried to fix the situation by creating a new text box for this field on the update form (instead of the existing one), but got the same error. Please advise, thanks. F. Barth
 
you could try to force an update to the recordsource of
the form?

is the underlying recordsource updatetable?
(copy paste in to a query and see if you can add new
records)

is it a linked table (with primary key?)

-----Original Message-----
Hello,
I posted on this awhile ago, and never got a
Click to expand...
solution. This issue is discussed in KB article 121512,
but its proposed solutions don't work for my situation
(see #2 below). I have done the following to try to
resolve it already:
1- used message box to show the number of characters I
Click to expand...
was trying to use for that field (was 9, which is the size
of that field in the table to which the form is bound)
2- Have been able to edit this field successfully
Click to expand...
directly into the table - and a different form where new
records are entered is able to accept the 9 characters for
this field (the problem occurs on a modify-existing-data
form)
3-On a development copy of the database, I have tried to
Click to expand...
fix the situation by creating a new text box for this
field on the update form (instead of the existing one),
but got the same error. Please advise, thanks. F. Barth
 
Gandalf,
Yes, it's in a linked table with a primary key.
(Frontend/backend). As mentioned, I've been able to edit
the table to which this form is bound. Users commonly
edit other fields via the same update form (which is
giving so much trouble over this one field). This form
is only for updating existing records; a different form
handles adding new records. F. Barth
 
Back
Top