Solved Replace multiple spaces

[jack555]

Replace(me.txtName,"  "," ")

above code can be used to remove double spaces between two words in a string. However, if there are three or four spaces that randomly occurs, how can we strip all these extra spaces and keep only one space? Tried adding nested "replace" without success.

Any suggestions are welcome.

 

[arnelgp]

me.txtName = Replace(me.txtName,"  "," ")
Do While Instr(1, Me.txtName, "  ") <> 0
    me.txtName = Replace(me.txtName,"  "," ")
Loop

 

[theDBguy]

Hi. You could also check this out.

Code Snippets

 

[jdraw]

Depending on how many occurrences you anticipate, you could try

Replace(me.txtName," "," ",,9)

where 9 is >= the number of occurrences