auto generate code

[concrete]

can i define a field so it generates an random code of 8 caracters?

[RussBaker]

This will work for using all the uppercase alphabet letters. If you want to extend it to lowercase and/or numbers etc, then add these characters to the text string and change the number "26" (which is the length of the text string).

Middle("ABCDEFGHIJKLMNOPQRSTUVWXYZ",Int(Random*26 + 0.5),1) &

Middle("ABCDEFGHIJKLMNOPQRSTUVWXYZ",Int(Random*26 + 0.5),1) &

Middle("ABCDEFGHIJKLMNOPQRSTUVWXYZ",Int(Random*26 + 0.5),1) &

Middle("ABCDEFGHIJKLMNOPQRSTUVWXYZ",Int(Random*26 + 0.5),1) &

Middle("ABCDEFGHIJKLMNOPQRSTUVWXYZ",Int(Random*26 + 0.5),1) &

Middle("ABCDEFGHIJKLMNOPQRSTUVWXYZ",Int(Random*26 + 0.5),1) &

Middle("ABCDEFGHIJKLMNOPQRSTUVWXYZ",Int(Random*26 + 0.5),1) &

Middle("ABCDEFGHIJKLMNOPQRSTUVWXYZ",Int(Random*26 + 0.5),1)

If the calculation is unstored, it will update everytime you access the record. So, depending on your intended use, you might want to leave it as a stored calculation.

Also, if this is for password generation, then its easy to modify this calc if you want to set rules like the Password must start with a capital letter, the 3rd character must be a number etc, etc. You could also consider removing "I" and "O" from the string (now 24 long) to remove possible confusion between "I" and one, or "O" and sero.