If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#2
|
|||
|
|||
text control
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 |
Thread Tools | |
Display Modes | |
|
|