saving long text to a memo field

[Icepickle]

I have a text box on a form, and when a button is clicked it runs a code to save the contents of the text box to a memo field in a table. Im using the DoCmd.RunSQL UPDATE command to send the contents of the text box to the memo field, but with long strings get cut off after a hundred characters or so, and the last couple characters are garbled. Why is this, and is there a different method to accomplish the transfer? I dont want to have the text box and field directly bound, so i need to do it with code. thnx in advance for your help

 

[jimbrooking]

Sounds nasty. I do similar things in a number of databases, and have never seen the problem. Coult you post the code you're using?