A Zero-length string, i.e.
is not the same thing as Null !
Why not just use
MsgBox "This field can't be empty"
Cancel = True
Thid includes anything except the stated Cases.
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via AccessMonster.com