Access: IF-THEN-ELSE Statement

In Access, the IF-THEN-ELSE statement can only be used in VBA code.

The syntax for the IF-THEN-ELSE statement is:

If condition_1 Then
   result_1

ElseIf condition_2 Then
  result_2
...
ElseIf condition_n Then
   result_n

Else
  result_else

End If

condition_1 to condition_n are evaluated in the order listed. Once a condition is found to be true, the IF-THEN-ELSE statement will execute the corresponding code and not evaluate the conditions any further.

result_1 to result_n is the code that is executed once a condition is found to be true.

Note:

If no condition is met, then the Else portion of the IF-THEN-ELSE statement will be executed.

It is important to note that the ElseIf and Else portions are optional.

VBA Code

The IF-THEN-ELSE statement can only be used in VBA code.
First, let's take a look at a simple example.

If [Region] ="N" Then
[RegionName] = "North"
End If

Next, let's take a look at an example that uses ElseIf.

If [Region] ="N" Then
    [RegionName] = "North"

ElseIf [Region] = "S" Then
    [RegionName] = "South"

ElseIf [Region] = "E" Then
    [RegionName] = "East"

ElseIf [Region] = "W" Then
    [RegionName] = "West"

End If

Finally, let's take a look at an example that uses Else.

If [Region] ="N" Then
    [RegionName] = "North"

ElseIf [Region] = "S" Then
    [RegionName] = "South"

ElseIf [Region] = "E" Then
    [RegionName] = "East"

Else
    [RegionName] = "West"

End If