How to remove leading characters in a text field?

[Guest]

If have a database that is created by importing a delimited text file.
Some of the text fields in the text file are padded out by using leading
zeros.
Once I have the data in an Access table, how can I strip the leading zeros
away to leave me with the data I actually need?

 

[Ken Snell [MVP]]

Use the Val function in an update query to easily do this:

UPDATE TableName
SET TextFieldName = CStr(Val([TextFieldName]);