code to remove "," from a form

  • Thread starter Thread starter Simon
  • Start date Start date
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
 
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
Click to expand...

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.
 
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.
Click to expand...

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
 
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
 
Back
Top