How can I do a Case Sensitive Seek or Find in DAO or ADO...

Thanks!

JET is not case-sensitive, so you will have to use a VBA function that is.

The Find string will be something like this:
strWhere = "StrComp([Field1], ""Text2Match"", 0) = 0"
rs.FindFirst strWhere

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Alain Vaillancourt" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> How can I do a Case Sensitive Seek or Find in DAO or ADO...