Access When form
Completing Conditions tab

  1. About 
  2. New 
  3. Conditions 
  4. Advanced 
  5. Pages & Classes 
  6. History 
  7. More... 

Use the Conditions tab to enter or revise an Access When condition rule that can be expressed as a single Boolean expression, or the conjunction (AND or OR) of one or more Boolean expressions.

Each node on the conditions tree defines a single comparison or other condition that evaluates to True or False. The Access When condition rule evaluates to True only if all nodes evaluate to true. While the order of nodes may affect computational performance, order does not affect the outcome of the Access When condition rule evaluation.

Using the conditions tree

The top node is labeled When. To create the first expression:

  1. Double-click the link beneath the When node.
  2. The Condition dialog appears, and contains the default condition, which compares two values.
  3. Enter properties, literal constants, or function calls and parameters in the fields, and select a relational operator.
  4. Optionally, select the down arrow ( ) at the end of the row for a list of standard conditions (derived from function alias rules). If you select [expression evaluates to true], use the Expression Builder for guided assistance; click the magnifying glass icon () to open it. See About Expressions.
  5. Click OK to close the dialog and display the condition on the tree.

To add, edit, or delete conditions, or to create groups of nested conditions, select a node and open the context menu by either:

Use these options:

The conditions and logical operators you enter on this tab also appear on the Advanced tab's Condition array and Logic String field.

Up About Access When rules