As far as I know searches on an Access database are not case sensitive. Searches on only certain types of data sources are case sensitive but not an MDB. Whether a search can be case sensitive is definded by the database.
You have to create an extension to your search...at best create a function that gets passed to it the recordset, field to search on, criteria for the search, and a value to identify if the search is to be case sensitive. That way you are not duplicating code. And then use thefollowing code:
'Search the file until the Criteria is found
bRecordFound = False
rsWork.MoveFirst
rsWork.Find "Project = '" & cboSelection & "'"
bRecordFound = Not rsWork.NoMatch
If bRecordFound Then
bRecordFound = False
Do Until rsWork.EOF
strFindResults = rsWork!Project
bRecordFound = StrComp(strFindResults, cboSelection, vbBinaryCompare)
If Not bRecordFound Then
rsWork.FindNext
Else
Exit Do
End If
Loop
End If
'Here assign the Functions return value to strFindResults
If bRecordFound Then
'When found, retreive information
Another way would be to clone or copy the Recordset, set its' Filter to cboSelection and Requery it. Then use a 'Do Until .EOF' Loop and use the same comparison code as above, using MoveNext if there was no match.
(Note: The Filter method is only for a DAO/Jet Recordset)