The table below contains all of the current constants you will find in the Expression Editor.
| Constant | Description | Example |
|---|---|---|
| String constants | String constants must be wrapped in apostrophes. | [Country] == 'France' |
| String constants (with apostrophe) | If a string contains an apostrophe, the apostrophe must be doubled. | [Name] == 'O''Neil' |
| Date-time constants | Date-time constants must be wrapped in '#'. | [OrderDate] >= #1/1/2009# |
| True | Represents the Boolean True value. | [InStock] == True |
| False | Represents the Boolean False value. | [InStock] == False |
| ? | Represents a null reference or DBNull.Value. | [Region] != ? |