ID Number 2

[Drofder2004]

Hi
I need help making a Long Integer starting at 00001 going up(instead of starting at 1).

Is there a way of doing this without entering the Visual Basic coding?

Thanks for any help.

 

[BNPMike]

00001 is 1 is 00001. If you want to display 1 as 00001 then just turn it into a text field and add some leading zeros. You can still keep the underlying long integer as it is.

 

[MA04]

Hi,

Just enter 00000 in the format property of the id in the tables design view.

HTH,

M-.

 

[BNPMike]

I think you deserve a star there M. Not seen that before.

 

[MA04]

Thanks for the star BNPMike.

 

[Drofder2004]

Nice 1 M, definitly require a star