Member Avatar for Anuanusha

I have just a user form in access 2007 with a text box and a Save command.
MY code:

Private Sub Save_Click()
If School.Value = "" Then
MsgBox ("Text Box is empty")
else
Msgbox(" Not Empty")

End If
End Sub

When the Save is clicked, and the text box is empty, the second statement is executed with message "Not Empty".
Why not first statement is exected first??

  • 3 Contributors
  • 2 Replies
  • 183 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for LastMitch

I have just a user form in access 2007 with a text box and a Save command.

What are you trying to save? Are you exporting a doc?

Member Avatar for Reverend Jim

I'm going to go out on a limb here and say that maybe the text box isn't empty. Maybe it just looks empty. It could have blanks in it. Set a breakpoint at the start of the if and look at the value in the debugger.

Edited by Reverend Jim
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.