Hi,
On a form I have an autonumber, which I display with leading zeros, e.g. 001, 002 etc. I then want to insert this info into a text field, so I end up with IS\001, IS\002 etc.
I have the following code in an after update
Me.SOP_Number = "IS\" & Me.Autonumber
however this drops my leading...