Full Version: If Variable = Blank or Blank Help
UtterAccess Forums > Microsoft® Access > Access Forms
Can anyone tell me why this is giving me a type mismatch error and how to fix it. If i take away the, OR "0" , it works.
If Me.Controls("N_STP" & stp & "_Internal_SP") = "" OR "0" Then

Thank you,
It more than likely needs to be this:
If Me.Controls("N_STP" & stp & "_Internal_SP") = "" OR Me.Controls("N_STP" & stp & "_Internal_SP") = "0" Then
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.