Random Number as field default

B

Brad Holtz

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
 
T

TC

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random Password Generation 0
prevent duplicates in random numbers 4
Random numbers, letters, pictures? 6
generate a sequence of random numbers 1
Finding the proper style field and the numbered paragraph value within the style 0
How random is Rnd 12
Generate 12 random numbers 13
Random number query question 12

Top