Autoserial - increment and format

[CommiC]

Hello,

To solve this I need a couple of hours to learn. I know there

are guys out there that write this down in a minute.

That's why I ask:

I need my serial in a format with always the same amount of digits.

Now it is ID1, ID2, ID3 etc.

I need ID0001, ID0002, ID0003

How do I setup the validation to get this result?

Thanks 4ur time

John

[Fenton]

Well, if you "pad" the serial "text" number to start with, to the maximum expected number of places, then it will be the same (until you go over, but that would be true of any safe method; methods that "force pad" to a set number of digits will break your solution if they go over the maximum number).

Just add zeros in the Options, Auto-enter, Serial Number dialog. The field should be text, not number.

0000001

0000002

will be 7 digits up to ten million.

The fact that you say "validation" makes me wonder whether you're talking about an auto-entered ID, or a user entered ID. If it is user-entered, you would use validation, using the Length(the field) function. You don't want to confuse the two different types of IDs, as they are (or should be) considered somewhat differently.