Wednesday, August 13, 2014

Zoom Box

Better view


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.

New Folders


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

No comments: