Free E-Books

n Date/Time: Return date and/or time values.
n Financial: Perform financial operations (such as NPV) on numeric values.
n Mathematical: Perform mathematical operations (SQRT) on numeric values.
n String manipulation: Transform, combine, or otherwise manipulate strings.
Immediate window
Microsoft Visual Basic has an Immediate window that you can use to test your code or functions.
Figure 13-7 shows the Immediate window containing two lines of text??”the UCase() function
and its return value.
NOTE
456
Programming Microsoft Access Part II
FIGURE 13-7
The Immediate window demonstrating the UCase() function.
The Immediate window is a nice tool for checking on how a function works.
Activate the VBA editor by pressing Ctrl+G or by right-clicking a module in the Navigation Pane
and selecting Design View from the shortcut menu. When you are in the VBA editor, select View ???
Immediate Window or press Ctrl+G. When you are active, use the print command (a question
mark: ?) to display the results of a function.


Pages:
945 946 947 948 949 950 951 952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 968 969