Mark dot to every space of the words 1

[Access2007]

Hi, can anybody here has the idea on how to do this?

mc carry smith COVERTED TO THIS mc.carry.smith

BIG THANKS IN ADVANCE..

 

[PHV]

Have a look at the Replace function:

strNew = Replace(strOld, " ", ".")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Access2007]

THANK YOU VERY MUCH MAN! ! !

 

[dhookom]

Correct answer within about 1/2 hr deserves a star.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]