case-sensitive notinlist

M

Mr 1604

My combo box displays case-sensitive entries for which I need a notinlist
event to occur if the user changes the case of a letter. Any suggestions on
how to do this?

Thanks.
 
D

Douglas J. Steele

Unfortunately, Access doesn't really support case-sensitivity.

You'll have to write code that looks at what was typed in, and compares it
to what's in the table using the StrComp function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User can't share a PowerPoint deck - "only document owners can share their documents" 0
Word OLE to check spelling in text box 1
OLE Word spelling 0
Create form with checkbox les that expand and collapse sections of the form? 0
Keep First Letters, with exceptions 0
NotInList trapping space 2
Improving Macro That Keeps First Letter 0
Can't save my Office documents (after computer rebuild and reauthorization) 0

Top