Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating random Passwords

Status
Not open for further replies.

tenz

IS-IT--Management
Aug 13, 2002
18
US
I am trying to a create a random password that consists of 4 random numbers. I have been using Autonumber with the new value as Random, but it gives me a number with about 8 numbers. Does anyone know what I can put in the Format field so it will only create a 4 digit number?
 
x = Left(Int(Rnd * 10000) & "000", 4)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top