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

In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.


In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!