When enter the password, how to change it to asterisk and compare it with
password in the table? thanks

if you're entering the password into a textbox control on a form, you can
set the textbox's InputMask property to Password. that does not *change* the
data entered by the user, but *displays* it as asterisks.

you can use a DLookup() function to return the correct password from the
table and compare it to the value entered in the textbox. if you're not
familiar with DLookup(), see Access Help for more details.

hth


"Huayang" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When enter the password, how to change it to asterisk and compare it with
> password in the table? thanks
>
>

What is to stop someone reading the passwords out of the table?

You should //never// store a plaintext password. You should only store
the /hash/ of the password. Google on "hash functions" for more
information. "MD5" is a common hash function for storing passwords.

HTH,
TC