Eqv Operator

Used to perform a logical equivalence on two expressions.

Syntax

result = expr1 Eqv expr2

Remarks

If either expression is a Null, result is also a Null.  When neither expression is a Null, result is determined according to the following table:

If expr1         And expr2       The result
is                  is                     is

True              True                True

True              False               False

False             True                False

False             False               True

The Eqv operator performs a bit-wise comparison of identically positioned bits in two numeric expressions and sets the corresponding bit in result according to the following truth table:

If bit in          And bit in         The result
expr1 is         expr2 is            is

0                   0                       1

0                   1                       0

1                   0                       0

1                   1                       1

Arithmetic Operators

Comparison Operators

Concatenation Operators

Logical Operators

Operator Precedence

Other Operators

Eqv Operator Example

The example displays a message that depends on the value of variables A, B, and C, assuming that no variable is a Null.  If A = 10, B = 8, and C = 6, both expressions evaluate True.  As a result, the Eqv expression also evaluates True.  To try this example, paste the code into the Declarations section of a form.  Then press F5 and click the form.

Sub Form_Click ()

Dim A, B, C, Msg                      ' Declare variables.

A = 10: B = 8: C = 6                  ' Assign values.

If A > B Eqv B > C Then               ' Evaluate expressions.

Msg = "Both expressions are True or both are False."

Else

Msg = "One expression is True and one is False."

End If

MsgBox Msg                            ' Display results.

End Sub