Replace Spaces

[JOHN SMITH]

Hi,

I have a text field that has the folling data:

6868- 1
6560- 2
6566-2

how can i remove the empty spaces so that i end with something like:

6868-1
6560-2
6566-2

Thank you All

 

[Lynn Trapp]

Replace([YourTextField]," ", "")

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html