Formatting Autonumber

[gpbuckley]

Hello: I have a form designed that needs a distinct number for each record entered. I am using autonumber but need to set it in 7 numeric digit form (eg 0000001, 0000002, 0000003 etc). Can anybody help? Many thanks.

 

[JANR]

This has recently been discussed here: http://www.access-programmers.co.uk/forums/showthread.php?t=190653&highlight=format+number

Read the entire tread espessially some of the warning of NOT to do this.

JR

 

[MStef]

Format properties for this field put 0000000 (in the table and in the form).

 

[gemma-the-husky]

but please understand what you are getting with an autonumber. it is not guaranteed to be no more than 7 digits, and is certainly not guaranteed to run in sequence,