Random Number as field default

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

Guest

I need to generate a positive, 10-digit number as a default for a field on a form. Currently, the default is set to:
=Int((989898989-101101010+2)*Rnd()+101101010)

The results are random, but repeatable. How do I set "randomize" in this context?

Is there a better way?

Brad
 
Try doing a Randomize in the Open or Load event of the form.

HTH,
TC


Brad Holtz said:
I need to generate a positive, 10-digit number as a default for a field on
Click to expand...
a form. Currently, the default is set to:
 
Back
Top