Text Field Format 2

[RobPotts]

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 zero's, how can I format this field to get the correct format




Rob! [Bigcheeks]
Process and Procedure are the last hiding place of people without the wit
and wisdom to do their job properly.

 

[PHV]

Me!SOP_Number = "IS\" & Format(Me!Autonumber, "000")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[RobPotts]

Hi,

Thanks for this, I tried loads but couldn't get it to work, then one small bit of code!........

Thanks again, have a star



Rob! [Bigcheeks]
Process and Procedure are the last hiding place of people without the wit
and wisdom to do their job properly.