Removing leading zeros

[Guest]

I have an imported table in an Access database that has a field with leading
zeros.
Some of the data contains 2 or 3 leading zeros but the field length is the
same. How can I trim these leading zeros?

 

[Guest]

Assuming the remainder of the data is numeric, convert it to integer (or
other numeric type) and then back to string:

CStr(Cint(SourceData))

HTH,
Barry

 

[ibeetb]

you can use Format([Field Name]),"")