Riddle me this! Cant make field not be null

[burrina]

I have a combo on my form that has to have a value in it. The field is Bank. I have this code on the Lost Focus and OnExit Events and still it does not make it work. Nothing happens, no message, no set focus???

If IsNull([Bank]) Then
MsgBox "You did not select a bank account,Select or else Cancel"
Me.Bank.SetFocus
End If

[Bob Fitz]

Try:

If Nz(me.Bank,0) = 0 Then
MsgBox "You did not select a bank account,Select or else Cancel"
Me.Bank.SetFocus
End If

[burrina]

Nope, it did not like that either. ??? Hmm! It is a text field, and not a numeric value though, but still?

[burrina]

MY Apologies, I had left the field with a control source and it should not have had one.

Thanks,