RE: Repost - RunTime Error - Field too small

See comments inserted below

"'69 Camaro" wrote:

> Hi, Paul.
>
> > Any other ideas??
>
> 1.) Verify that the text box is bound to the field you think it is.

Done. 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.

Done, didn't help.

Rebuilt the table from scratch, didn't help either.

>
> 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

Here's the select statement currently being used the populate the combo box.

SELECT [tblFacilities].[FacilityName] FROM tblFacilities ORDER BY
[FacilityName];


Here is the DLookup statement in the AfterUpdate event of the FacilityNumber
combo box.

[DestHospName] = DLookup("FacilityName", "tblFacilities", "Code=" &
Me.DestHospNumber)


So when you select a hospital number from the HospitalNumber combo box, as
long as the name is less than 30 characters, the FacilityName combo box
populates fine.

If the name is longer that 30 characters, I get the error message. I will
also get the error message by selecting a name longer than 30 characters
directly from the FaciltiyName combo box.


Thanks in advance....





>
> 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: Repost - RunTime Error - Field too small
    ... Jet won't store changes to the external database in the table ... post your DLookup() code and example data that ... I get an error message and I cannot ... > It seems to die if the field has more than 30 characters. ...
    (microsoft.public.access.formscoding)
  • Re: non SGML character escape
    ...  If the validation fails, kick it back to the user with a big ... red X and the error message "No dice." ... Even though the database ... Some of the characters are not being escaped.... ...
    (comp.lang.java.programmer)
  • 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)
  • Re: Copying/Pasting into Update Query
    ... Once you have a value stored in a column with 890 characters, ... expect to do with it functionally within a database? ... > query memo field. ... I keep getting the error message, ...
    (microsoft.public.access.queries)
  • Passwords
    ... I have a password field in a database. ... user can only type in 7 characters for a password. ... more an error message will appear? ...
    (microsoft.public.access.formscoding)