Combo Box default message

K

Ken

I got a "combo box" with the "Limit To List" set
to "Yes". When I type in a value which is not in the
list, it will give me a default message, saying "The text
you entered isn't an item in the list. Select an item
from the list, or enter text that matches of of the
listed items." How could I turn off this default message
box?
 
K

Ken Snell

Put your own code in the NotInList event. Something like this:

Response = acDataErrContinue
MsgBox "You must select an item from the list!"
 

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

Top