How to truncate the leading zeros

J

Jeremy Nelson

Hi!

I have a text field like 000076534 in one of my tables.
How do I get rid of the leading zeros. Any help will be
greatly appreciated.

Thanks.
 
K

Ken Snell

Do you still want it to be a text field when done?

MyTruncatedNumber = Format(Val([MyField]), "@")
 
Top