To/From Code

	Languages
BROWSEBYLANGUAGE Access VBA ASP Classic C# C++ C++/CLI Delphi Delphi Prism Java JavaScript ObjectPAL Perl PHP VB Classic VB.Net

	Categories
BROWSEBYCATEGORY +Tool Basics +Language Basics +Language Details +Data Structures -Statements Exception Trapping If Statement◄╣ +Operators +Commands +Database +OOP Basics +OOP Details

	Access VBA Guides
Access VBA To/From Conversion Guides Access VBA and ASP Classic Access VBA and C# Access VBA and C++ Access VBA and C++/CLI Access VBA and Delphi Access VBA and Delphi Prism Access VBA and Java Access VBA and JavaScript Access VBA and ObjectPAL Access VBA and Perl Access VBA and PHP Access VBA and VB.Net

Cross Ref Guide

ACCESS VBALANGUAGE

Access VBA

ACCESS VBAANDVB CLASSICTOC

Overview

+Tool Basics

Report Tools Overview

+Language Basics

+Language Details

+Data Structures

Array

Associative Array

Pointers

-Statements

If Statement◄╣

+Operators

+Commands

+OOP Basics

+OOP Details

	Members-Only
Sign in to see member-only pages.

► KB ► To/From Guides ► Access VBA ► Statements

If Statement (Cross Ref > Statements)

By Mike Prestwood

Access VBA versus VB Classic: A side by side comparison between Access VBA and VB Classic.

Statements

Common statements such as if statements, loops, etc.

If Statement

[Other Languages]

Access VBA: If..ElseIf..Else..End If

The End If is optional if you put your code on a single line.

Syntax Example:

//Single line example.

If X = True Then MsgBox "hello"

//Complete example.

If X = True Then
  '>>>do something.

ElseIf Y = "ABC" Then
  '>>>do something.
Else
  '>>>do something.

End If

VB Classic: If..ElseIf..Else..End If

The End If is optional if you put your code on a single line.

Syntax Example:

//Single line example.

If X = True Then MsgBox "hello"

//Complete example.

If X = True Then
  MsgBox "hello"

ElseIf Y = "ABC" Then
  MsgBox "goodbye"
Else
  MsgBox "what?"
End If