Remove the leading blank space

[crystalfun]

I have a field called Asset ID which is made up of a 7 character ID such as "0123456" There seems to be a blank space before the beginning of each number.

How can I remove the blank space from the front of the record? In Excel I can use Edit,replace but that doesn't seem to work here.

 

[PaulBricker]

Use the Trim() function to remove leading and trailing spaces or LTrim() to just remove the leading space.

Trim([fieldname])



Paul