I have a Database that has a free form text box with up to 255 characters in it. The problem I am having is that if someone puts in a special character mostly a " ' " then the information will not write to the table.
Is there a way to remove the single quote or any other special characters before I write it to the table.
If I can't remove it is there a way to block the entry of it. If the rep keys in the word "Can't" for example it would kick out an error message.
I have searched the forum and not found the information that will take care of this for me.
I have tried several different things I have seen on this forum and others with no luck.
Any help would be greatly appreciated.
Is there a way to remove the single quote or any other special characters before I write it to the table.
If I can't remove it is there a way to block the entry of it. If the rep keys in the word "Can't" for example it would kick out an error message.
I have searched the forum and not found the information that will take care of this for me.
I have tried several different things I have seen on this forum and others with no luck.
Any help would be greatly appreciated.