RE: Repost - RunTime Error - Field too small

Hi, Paul.

> Any other ideas??

1.) Verify that the text box is bound to the field you think it is.

2.) If this is a linked table, don't use the Linked Table Manager or VBA
code to relink (or refresh the link to) the table after making changes to the
table. Delete the link, then create a new link to the table in the back end.
Otherwise, Jet won't store changes to the external database in the table
link information, such as a new database password or information on the
table's structure, including added and deleted fields, changed field data
types or sizes, and the table's statistics.

3.) If all else fails, post your DLookup( ) code and example data that
Access chokes on. You may have a logic error that someone else here can help
you locate.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.


"Paul B." wrote:

> Please see below thread....
>
>
> "Paul B." wrote:
>
> Thanks for the suggestions, tried them but no joy.
>
> Any other ideas??
>
> >
> "Ofer" wrote:
>
> What happen when you try to insert data into the field directly, and not by
> using Dlookup?
>
> Is it a link table? if so, and you changed the field size, try and relink
> the table.
>
> In the Dlookup, add left 254 and check what happen then
> Me.FieldName = Left(Dlookup(.....),254)
>
> Try compact and repair to the MDB where the table is located in.
>
> --
> \\// Live Long and Prosper \\//
> BS"D
>
> > >
> "Paul B." wrote:
>
> I am using a Dlookup statement to update a text box which is working fine
> except for some of the entries. I get an error message (below) and I cannot
> figure out what is wrong.
>
> The table field is 255 characters (I know it's too big, but for now I still
> working on it) and the forms text box is bound to the field in the table.
>
> I have tested the different text formats, and it doesn't seem to care about
> brackets, apostrophies, dashes or other symbols.
>
> It seems to die if the field has more than 30 characters.
>
> Any ideas would be appreciated...
>
> If you are interested, this is the error:
> ---------------------------------------------------------------------------------------------
>
> Run-Time error '-2147352567 (800200009)'
>
> The field is too small to accept the amount of data you attempted to add.
> Try inserting or pasting less data.
>
> -----------------------------------------------------------------------------------------------
>
.

Relevant Pages

  • Re: Autopopulate
    ... Because you have already queried the database once to populate the ... So in each tab I have the subforms set up with the fields in a 1 row ... I orginally wrote an SQL statment but I keept getting "The record has ... The DLookup was easy to use and it didn't create the "The record has ...
    (microsoft.public.access.forms)
  • RE: Repost - RunTime Error - Field too small
    ... Jet won't store changes to the external database in the table ... Here is the DLookup statement in the AfterUpdate event of the FacilityNumber ... If the name is longer that 30 characters, I get the error message. ...
    (microsoft.public.access.formscoding)
  • Re: I am stumped....TimeValue problem
    ... It ought to work but I'm still getting the blink ... afternoon at work working on the database, ... I opened the database on the new computer the DLookup ... will work until the clock goes 1 second past midnight and then it won't find ...
    (microsoft.public.access.formscoding)
  • Re: Form Behavior Problem
    ... > The form has a textbox that uses a Dlookup call. ... the same button stores the value I want written to the database when they ... push it. ...
    (microsoft.public.access.formscoding)
  • Re: Before Update
    ... Use DLookup() to see if the value is already there. ... Tips for Access users - http://allenbrowne.com/tips.html ... > error message " This is already in the database,. ...
    (microsoft.public.access.formscoding)
Loading