Random Password Generate to text field

[nono5551212]

Hello,



How can I generate a random string to a text field from a button. I'm an access noob.

Say I have a form..
On the form I have:

X1 Button (BTN-Generate-Password)
X1 Text Field (TF-Generated-Password)

How can I make it so when the button is clicked a random string will appear in the text box

Private Sub BTN-Generate-Password_Click()

(What Do I put here?) (Will it populate the Text Field?)

End Sub

- 9 Characters
- Upper and Lower Case
- Numeric & Alpha Numeric
- These Characters (!@#$%)

Thank you for taking the time to read my post.

[June7]

Bing: Access VBA random password

Review:

http://answers.microsoft.com/en-us/o...7-8be0ea4ca651

http://www.freevbcode.com/ShowCode.asp?ID=831