code to remove "," from a form

S

Simon

I would like a code to stop having and "," in the test

I will run the code on exit

what code do i need to use to do find and replace "," with nothing

Thanks
 
C

CompGeek78

I would like a code to stop having and ","  in the test

I will run the code on exit

what code do i need to use to do find and replace "," with nothing

Thanks

Please give us more details about what you are trying to do. Is the
test that you refer to the name of a TextBox? Could there be multiple
occurrences of "," in whatever object you are trying to remove them
from?

Some sample data and a bit more detail would go a long way towards
letting us help you.
 
S

Simon

Please give us more details about what you are trying to do. Is the
test that you refer to the name of a TextBox? Could there be multiple
occurrences of "," in whatever object you are trying to remove them
from?

Some sample data and a bit more detail would go a long way towards
letting us help you.

Its a text field, where the user types in a delivery address, but i
want to stop the user using using "," in the line like 4, The
Street i want it to look like 4 The Street

Thanks

Simon
 
K

kc-mass

Let's say you have a variable "strNames" with the following value: "Ed,
Peter, Tom, Ron"

Try something like this:

Replace(strNames, ", ", " ")

Would yield strNames = "Ed Peter Tom Ron"

Regards

Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top