Case sensitive password

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Don - 17 Jan 2008 21:40 GMT

I have a assigned a password format to a field in a table I've created. How
can I make this field case sensitive?

Thanks.

Signature

Don Rountree

Reply to this Message

Douglas J. Steele - 17 Jan 2008 23:12 GMT

Not easily. Realistically, Access isn't case-sensitive.

If you're saying that you want to have a case-sensitive SELECT statement,
you can use the StrComp function:

SELECT Field1, Field2
FROM MyTable
WHERE StrComp(Password, "MiXeDCaSe") = 0

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I have a assigned a password format to a field in a table I've created.
>How
> can I make this field case sensitive?
>
> Thanks.

Reply to this Message