Linked Table field...strip off leading zeros of text

  • Thread starter Thread starter Inyo55
  • Start date Start date
I

Inyo55

My table is linked to a text file. One of the numbers in
that text file has 2 leading zeros. I do not want the
leading zeros to be imported into the Table. How do I
strip off the two leading zeros in the Text Field? I
cannot change the field to a Number; it must remain as
Text because of other things in the DB that join to it.

thanks,
Bob
 
My table is linked to a text file. One of the numbers in
that text file has 2 leading zeros. I do not want the
leading zeros to be imported into the Table. How do I
strip off the two leading zeros in the Text Field? I
cannot change the field to a Number; it must remain as
Text because of other things in the DB that join to it.

thanks,
Bob
Click to expand...

Try appending

Cstr(Val([fieldname]))
 
Back
Top