Add Functions To Access Expressions. In the expression we will see if the middle initial field is blank or is null. All you do is create a standard code module and then inside of that code module you can add as many new custom functions.
Next you dont have to worry about balancing parentheses and square brackets as VBA allows you to write the same expression above but simply like this. In the Other group select Module from the drop-down list on the far right side of the Ribbon. However you cant do too much with expressions without eventually learning how to add functions to them.
The complete Expression for the function call is.
To make sure theyre saved. Access does include a feature that lets you take your expressions to the next level and its called functions. Then try the expression builder again. Add functions to Access expressions Access has lots of built-in functions you can use to build expressions.
