Random Autonumber

[Tru]

I have a autonumber random field "Customer ID" that sometimes generates
negative numbers is there a way to have this field generate positive numbers
only.

 

[Rick Brandt]

I have a autonumber random field "Customer ID" that sometimes
generates negative numbers is there a way to have this field generate
positive numbers only.

No. What I do in a few places is use Random AutoNumbers but display them as
Hex values. This produces a character/digit string that is always 6
characters long and there is never a negative sign.

Otherwise you would have to "roll your own" method for assigning the numbers
instead of using AutoNumber.

 

[Brian]

Is there a reason you are using Random instead of Increment?

 

[Tru]

Thanx! This was the first time i tried random autonumber i wont use it again.
But your hex format is a great idea.

 

[Tru]

Just to try it out, silly me!

Is there a reason you are using Random instead of Increment?