Multiple step operation failure

I have been struggling with this ADO error for a while now. It seems the solution is simple, the new value is longer than the actual field size. Refer to this post.