Runtime error - Field is too small

[Guest]

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.

-----------------------------------------------------------------------------------------------

 

[Guest]

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.

 

[Guest]

Thanks for the suggestions, tried them but no joy.

Any other ideas??