Case sensitive password

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

 

[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