Change warning message, not in list. 1

[LD1010]

Thanks for reading my post.

I have a combo box on a form with it's Limit To List property set to yes/true. If the user enters an item, in my case a date, that's not in the list a message box pops up stating "The text you entered isn't an item in the list." Is there a way to modify the message to say something different?

Any help would be much appreciated.

 

[Remou]

You can use the NotInList event for the combo:

Private Sub Combo0_NotInList(NewData As String, Response As Integer)
    MsgBox "Tut,tut"
    Response = acDataErrContinue
End Sub

http://lessthandot.com

 

[LD1010]

Thanks for the help Remou, just what I needed.