Question number format

[Nic]

Hi,
If i have a string of numbers in a text box on a form, how could i dictate the amount of digits? I would like the number of digits to be set. For example, if i type a number of 50, i would automatically like this to be displayed as 0050 (ie. a 4 digit number). Therefore if i type 150, it would appear as 0150.

Suggestions greatly appreciated,

 

[The_Doc_Man]

Create an explicit format string that includes leading zeros as part of the string template. Look up Access help on user-formatted numbers to see how to do this, then in the text box's Format tab, there is a way to define the formatting template.

 

[Nic]

Hi,
Thanks for the help, but im struggling with this one!
Iv searched access help for 'Explicit format string' and also 'User formatted numbers' but im not really sure what im looking for or where to start? Perhaps you could enlighten me further - (self tought beginner at this stuff)!

Many thanks in advance,

 

[Galaxiom]

TheDocMan is being just a little obtuse.
Simply put 0000 in the Format property of the textbox.

 

[Nic]

GREAT!
Thanks for that!
Oh so simple, but not somthing i could put my finger on!

Many thanks,