Full Version: If Variable = Blank or Blank Help
UtterAccess Forums > Microsoft® Access > Access Forms
Quadrant
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.
!--c1-->
CODE
If Me.Controls("N_STP" & stp & "_Internal_SP") = "" OR "0" Then

Thank you,
Mike
fkegley
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.