NotInList trapping space

[Rick Allison]

Okay, I give. Access 2000. NotInList option for a combo box.

I have everything working. User enters a value not in the list and a
warning message is displayed.

User enters a space, nothing else just hits the space bar, and viola it
works. No NotInList invoked. Data is entered into the system.

What simple thing am I missing?

 

[Tom van Stiphout]

On Tue, 13 Jan 2009 19:12:37 -0600, "Rick Allison"

Please post your NotInList event procedure.

-Tom.
Microsoft Access MVP

 

[Rick Allison]

Here's my NotInList code

Private Sub cboJudgeID_NotInList(NewData As String, Response As Integer)
MsgBox "A judge has not been selected" & vbCrLf & _
"Add the judge first then select him/her for the assignment", _
vbInformation + vbOKOnly, "Need Judge"
End Sub

Nothing fancy yet. When I type in just a space and leave the text box, the
not in list control does not work. I have checked the bound table and there
is no row there with just a space. So space is in fact not in the list.

That's why I'm so puzzled.