Disappearing Zero "0" value

[brodaman]

Good day, Am having issue with all Zero value starting account numbers while entering them.
Where do I make my setting to retain the zero value.

Thanks.

 

[Gasman]

Good day, Am having issue with all Zero value starting account numbers while entering them.
Where do I make my setting to retain the zero value.

Thanks.

Use the Format property of the textbox that holds the account numbers, so 00000000 would be for 8 digit account numbers.

 

[moke123]

i believe if its a numerical datatype the leading zero is removed. if its text datatype it wont be. so unless your doing any math or sorting with it I would change it to text. note that text and numbers sort differently.

 

[gemma-the-husky]

if you want leading zeroes, then it makes sense for the account to be "text" rather than number, even if the value is numeric.

I would make all account numbers a constant length to avoid sorting issues.

To be honest though, a numeric key would work as well, and an autonumber would be fine as well.

 

[brodaman]

Use the Format property of the textbox that holds the account numbers, so 00000000 would be for 8 digit account numbers.

I simply dont understand please buttress: rolleyes:

 

[brodaman]

i believe if its a numerical datatype the leading zero is removed. if its text datatype it wont be. so unless your doing any math or sorting with it I would change it to text. note that text and numbers sort differently.

Have tried using text datatype which actually retain the Zero values but messed
my sorting...........any other way please

 

[Minty]

On your table in design view , in the format section put in 00000 or as many digits as you need to have displayed.

 

[gemma-the-husky]

Have tried using text datatype which actually retain the Zero values but messed
my sorting...........any other way please

how does it mess up your sorting?

are you using a fixed length code?
If not, how will you distinguish between these 2

00A
000A