There's nothing built into Access to do this that I'm aware of.
To do it manually, use the Replace statement multiple times.
strText = Replace(strText, ".", "")
strText = Replace(strText, ", ", "")
strText = Replace(strText, ":", "")
etc.
or
strText = Replace(Replace(Replace(strText, ".", ""), ",", ""), ":", "")
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)
"John Thomas" wrote in message
...
Is there a way to Remove all punctuation from a text string, without
identifying each type of punctuation, if not what is the best way to do it
with the text as a variable.
Thanks John