I am trying to replace any occurrences of an appostrophe before i insert the values into a table.
Which gives me the following error: Unclosed quotation mark before the character string '
How do you use the replace function when you are trying to find an appostrophe?
Code:
Replace([Title],''',Space(0))
Which gives me the following error: Unclosed quotation mark before the character string '
How do you use the replace function when you are trying to find an appostrophe?