Thank you so much for this information. That Invalid Use of Null error message caused me countless sleepless nights. I can't believe how incredibly easy IsNull() makes this. Finally, I can prevent command buttons from running when the user forgets to enter information.