Eliminate all spaces

[ABM]

Is there is function that will eliminate all spaces? Similar to TRIM but
would also eliminate spaces within the string.

 

[Jeff C]

--
Jeff C
Live Well .. Be Happy In All You Do

Is there is function that will eliminate all spaces? Similar to TRIM but
would also eliminate spaces within the string.

See if this post helps resolve your problem:

http://www.microsoft.com/office/com...ffice-access&lang=en&cr=US&sloc=en-us&m=1&p=1

 

[fredg]

Is there is function that will eliminate all spaces? Similar to TRIM but
would also eliminate spaces within the string.

In what context? In a Query?
NoSpaces:Replace([FieldName]," ","")