Number data type issue

[ad2]

Hi,

I have a client ID field that the user wants to enter as an 8 digit number. I've have the data type as number in the table.

The user wants to start with 00000001 and then continue, next 00000002, etc.

Access won't let the it start with a zero. Anyone know a way around this. I looked at the various fromats for the number data type but none seemed to address this.

Thanks,
Ad2

 

[PWise]

in table design by format of client ID put in as many zeros as your heart desirers

 

[ad2]

Sorry pwise, I don't understand your answer.

Currently in table design, the data type for client id is number. In datasheet view, the field will not take leading zeros as the user wants.

Are you telling me to somehow change the format?

 

[VRoscioli]

That's precisely what he's telling you to do. In the table design, go to the desired field and in the Format property enter the text:

00000000

-V

 

[ad2]

Got it. Thanks to both of you.

 

[Ed2020]

Bear in mind that this will not store all the leading zeros in the table- it will only display them. No numeric data type will store the leading zeros as they have no affect on the intrinsic value (00001234=1234).

If you want to actually store the leading zeros in your table you would need to change the field data type to text.

Ed Metcalfe.

Please do not feed the trolls.....

 

[ad2]

Thanks for the tip!