Function to eliminate spaces

[Terry]

I would like to have a control return the contents of a field, but without
the internal spaces. I know the trim function can eliminate the left and
right spaces, but is there a way to eliminate spaces inside of a string?

Example; "Dry Vac" Would return DryVac"
Thank you.
Terry

 

[Damon Heron]

newString =Replace("your string"," ","",,,vbTextCompare)

Damon

 

[KARL DEWEY]

Replace([YourField], " ","")

 

[Terry]

Works great - Thanks

Replace([YourField], " ","")
--
KARL DEWEY
Build a little - Test a little

I would like to have a control return the contents of a field, but
without
the internal spaces. I know the trim function can eliminate the left and
right spaces, but is there a way to eliminate spaces inside of a string?

Example; "Dry Vac" Would return DryVac"
Thank you.
Terry