Removal of spaces within character string

[Guest]

Access 2003. Wanting to generate a VBA "black box" routine to remove spaces
from within text strings of varying lengths. There is no issue with leading
or trailing blank spaces. Think of it as removing all the blanks between
words in a sentence. Seems there might be a tool or trick I'm just not
finding. As always thanks for the great help made available here.

 

[Allen Browne]

Try the Replace() function.

Replace space with nothing (zero-length string).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news[email protected]...