Format to 4 digit

[dixxy]

Hi,

I am trying to have a text box show valur like this "001" ,"002", "003" without the quotations...I always want it to show 3 digits. The data type for the feild is set to text.

How can i do this?

Thanks,

Sylvain

 

[PHV]

Have you tried a "000" format ?

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

 

[dixxy]

yes, but then i have code that changes it on a button click like this

Me.txtPurchaseOrderNumber = Me.txtPurchaseOrderNumber + 1
and it looses the "00"



Thanks,

Sylvain

 

[PHV]

The data type for the feild is set to text
Me!txtPurchaseOrderNumber = Format(Val(Me!txtPurchaseOrderNumber) + 1, "000")

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

 

[dixxy]

thanks...
that worked out fine.

Thanks,

Sylvain