Random Autonumber

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Tru said:
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.
Click to expand...

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.
 
Thanx! This was the first time i tried random autonumber i wont use it again.
But your hex format is a great idea.
 
Back
Top