For anyone who gets the same issue:

It appears that when you paste into an Access 2007 text box you retain some of the formatting tags that normally get stripped when pasting to a plain text field. Access 2007 now supports rich text in the standard text box so I guess, even when set to plain text, it is retaining some data that throws an error when passed into an ADO command.

To fix this issue I simply iterate the characters in the string, creating a new string based on the ASCII values. This drops whatever it is that causes the error.

Cheers