Free E-Books

It??™s confusing because you use the same word as
an expression and as a name, but the context in which the word is used is important. The general rule
is that names are surrounded by quotation marks (???) and identifiers may or may not be surrounded by
square brackets ([]), as explained later in this chapter.
NOTE
447
Using Expressions in Queries and VBA Code 13
Creating an expression
Expressions are commonly entered in Property windows, macro action arguments, and query criteria
grids. Expressions are often used within VBA statements as well. As you enter an expression
into a property box or grid cell, the text in the area shifts to the left so that you can continue to
enter the expression. Although it is easy to enter an expression in this manner, it is often desirable
to see the entire expression as you enter it. This is especially true when you are working with long,
complex expressions. Access has a Zoom box (opened with Shift+F2) that shows even the longest
expressions (see Figure 13-4).


Pages:
927 928 929 930 931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946 947 948 949 950 951