07 – Conditionals And Branching

In this post, we will be taking a look at Conditionals and Branching. The ability to use conditionals and branching constructs in MS Access is vitally important. They will enable you to make decisions based on the values of variables and act accordingly. Coding wouldn’t be possible without them.

List of topics covered:

• If…Then, Evaluating Expressions, Operators, Statement Blocks
• “AND” Operator
• Nested Expressions
• If…Then…Else…End If
• If…Then…End If and Statement Blocks
• If…Then…Else… End If
• If…Then…ElseIf…[ElseIf…] End If
• Expressions: Operators
• Boolean as an Expression
• Arithmetic Operators
• Arithmetic Operators on Strings
• Logical Operators
• And Operator
• Or Operator
• Not Operator
• Nested If Clauses
• Select…Case…Else
• Common Problems
• Too Many conditionals
• Too Many Expressions
• Very Long Select… Case Statements

Downloadable Content

Code Examples VBA Fundamentals

PDF

Videos

The If…Then Statement

The If…Then…Else Statement

The If…Then…ElseIf Statement

Select Case

Select Case In Action

Related Posts