In your question one your dim statements for a, b and c will be variants. Only D is declared as a boolean.
You need to explicitly state the data type each time otherwise it will be a variant
---
Paul Arrowsmith
|
Regarding...
Access VBA Logical Operators (and, or, not)
Languages Focus: Logical OperatorsLogical operators perform conditional and, or, and not operations. Some languages support both binary logical operators that link two and unary logical operators negate (make opposite) the truth value of its argument. Finally, some languages short circuit logic. For example, with this or that, if this is an expression returning true, then that is never executed.
Access VBA Logical OperatorsSame as VB. Access VBA logical operators:
| and |
and, as in this and that |
| or |
or, as in this or that |
| Not |
Not, as in Not This |
Access VBA never short circuits. Given the expression this or that as well as this and that, if this evaluates to false, then that is still executed.
|
|
Access
Print This
