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.
--
Don Rountree

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

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


"Don" <(E-Mail Removed)> wrote in message
news:6FE3CE63-0CF5-4C88-BC27-(E-Mail Removed)...
>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.
> --
> Don Rountree