[Neilk]

So I looked more carefully at the code and figured out how to exclude the last column.

I just needed to change (select * from...) to (select Billing,AccountNumber,CommentDateEx,CommentText from...)

Instead of replacing the invalid characters after the users type them. I am going to prevent my users from using them by using text validation on the Access Form feeding the SQL table. I put a text validation of ' Not Like "*[|\&~^]*" 'with a message box opening up telling the user not to use those characters. That might not be elegant, but at least the original user will modify what they write instead of me trying to figure out what their tilde etc was meant to be.

I am going to look at the source code for the SED utility this weekend, as I am sure I will need to learn how to replace more text in the future.

Thanks guys!