Closing mask if non-zero value

[sergran]

Hello, I need your help .... I should set up a condition which must be closed if the list has a mask of values
The mask contains a text box (list) on which associtata not appear in a list.
.


I wrote
[code] If KeyCode = vbKeyEscape And Len (list)> 0 Then
btnClose_Click
End If [/ code]

and I also tried with
[code] If KeyCode = vbKeyEscape And Not IsNull (Me.lista.value) Then
btnClose_Click
End If [/ code]

but the part in red cancels the command. In fact, I porvato to REMOVE and funziona.Come should I change the code?
thanks
Hello

[June7]

Try nesting the conditions:

If KeyCode = vbKeyEscape Then
If Not IsNull(Me.lista) Then btnClose_Click
End If

But that will allow non number values. Should this be limited to numbers?


Note that the ending CODE tag is [/code] without a space.

[sergran]

Thanks very much!!!!!!