String --> field using code (127 char limit)

[UniqueTII]

I'm using code to take a value from a query and add it to a table (can't use append for various reasons) and I'm hitting a 127 character limit when I pass the value. I still get the problem if I segment the string. Is there any way around this limit? It's causing me some pretty major problems.