How to concatenate strings: Delete spaces

[Brandon Johnson]

I was wondering how to take a string and completely eleveate the spaces
within. example:: Industrial Technology. so after the transition i
would like it to look like this: IndustrialTechnology. If anyone has
any thoughts please let me know.

 

[Guest]

Use the replace function to relace space with empty

Replace([FieldName]," ","")

 

[Wayne Morgan]

Try the Replace() function.

strString = Replace(strString, " ", "")

 

[Brandon Johnson]

Thanx to the both of you. It worked like a charm.