Help Cancatenating!

  • Thread starter Thread starter Ryan_R
  • Start date Start date
R

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
 
Use the Replace command

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