Case sensitive password

D

Don

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.
 
D

Douglas J. Steele

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
 
Top