A ABM Apr 7, 2008 #1 Is there is function that will eliminate all spaces? Similar to TRIM but would also eliminate spaces within the string.
Is there is function that will eliminate all spaces? Similar to TRIM but would also eliminate spaces within the string.
J Jeff C Apr 7, 2008 #2 -- Jeff C Live Well .. Be Happy In All You Do ABM said: Is there is function that will eliminate all spaces? Similar to TRIM but would also eliminate spaces within the string. Click to expand... 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
-- Jeff C Live Well .. Be Happy In All You Do ABM said: Is there is function that will eliminate all spaces? Similar to TRIM but would also eliminate spaces within the string. Click to expand... 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
F fredg Apr 7, 2008 #3 Is there is function that will eliminate all spaces? Similar to TRIM but would also eliminate spaces within the string. Click to expand... In what context? In a Query? NoSpaces:Replace([FieldName]," ","")
Is there is function that will eliminate all spaces? Similar to TRIM but would also eliminate spaces within the string. Click to expand... In what context? In a Query? NoSpaces:Replace([FieldName]," ","")
