case-sensitive notinlist

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mr 1604 - 20 Jul 2007 13:14 GMT

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.

Reply to this Message

Douglas J. Steele - 20 Jul 2007 14:45 GMT

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.

Signature

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

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

Reply to this Message