Access does not provide much room to enter long expressions in queries, forms, or reports.
You can drag the column wider, but there is a neater, quicker method.
With the insertion point in the field, hit: SHIFT+F2.
A Zoom box opens. Enter the formula and hit OK.
BTW: If you enter Field names in the Zoom box without square brackets, if the fields are recognized, Access will add the brackets.
See all Topics