NotInList trapping space

  • Thread starter Thread starter Rick Allison
  • Start date Start date
R

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?
 
On Tue, 13 Jan 2009 19:12:37 -0600, "Rick Allison"

Please post your NotInList event procedure.

-Tom.
Microsoft Access MVP
 
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.
 
Back
Top