Number format to allow leading zeros

[dawnd3]

How do I format a number field so it will allow leading zeros in the field. ie. 001

Using Access 2007

Thanks,

Dawn

 

[PHV]

Have you tried 000 ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dawnd3]

I did try that but it forces the leading zeros rather than it being optional. It is better than anything I have found so far though. Is there a way to make it optional?

Thanks,

Dawn

 

[PHV]

So, use a string, not a number.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MichaelRed]

optional implies some criteria for directing the optional activity?

so the criteria could be implemented in a UDF or, possibly, in some embedded format function of your report?



MichaelRed