Database Reference
In-Depth Information
▪ Tab: 9
▪ Enter: 10
▪ Return: 13
▪ Escape: 27
▪ Left arrow: 28
▪ Up arrow: 29
▪ Right arrow: 30
▪ Down arrow: 31
▪ Space: 32
▪ Forward Delete: 127
TIP
To find the code for an alphanumeric character or string of characters, use the
Code()
function. For
example,
Code (“c”)
returns the value 99 and
Code (“sp”)
returns 11200115.
There's one more wrinkle to keystroke detection. What if someone presses Shift plus the Tab
key? Since this is a common need, FileMaker has one more keystroke function:
Get(TriggerModifierKeys)
. This function, plus a little math, tells you which of the modi-
fier keys was pressed. Once again, special codes represent each key:
▪ Shift: 1
▪ Caps Lock: 2
▪ Ctrl (Windows) or Control (Mac): 4
▪ Alt (Windows) or Option (Mac): 8
▪ Command
⌘
(Mac only): 16
This list may seem to be missing some values, like 3 and 5. That's because
Get(TriggerModifierKeys)
—and its sister function
Get(ActiveModiferKeys)
—
add
the
values of all modifier keys to get their results. For example, Shift + Ctrl pressed together res-
ult in a value of 5. And, if you do some experimenting, you'll see that that's the only way to
get 5. This way, every combination of modifier keys results in a unique number.
