Help Cancatenating!

[Ryan_R]

Hi,

I am entering a number as text on a form. the number has spaces which i need
to keep in the original field, but I need to remove the spaces from the
number in another field on the form. example:

The original number:
6855 90 963 3081283

Corrected number:
6855909633081283

I need the second field to show this number without the spaces.

Any help is appreciated

 

[New Guy]

Use the Replace command

Replace(Me.FieldName, " ", "") Just substitute your field name in FieldName