OOps- hit the tab key!
Here is an example from Thomson's New Perspectives in Access:
1) code example to change the bypass key is available in Access VBA help. Search for "allowbypasskey property". You can use MS's code example (cut and Paste) found there for the sub SetByPassProperty() and function ChangeProperty
2) Add the following function to a code module:
Function SetByPassProperty(bValue as boolean)
Const DB_Boolean as long = 1
ChangeProperty "AllowBypassKey", DB_Boolean, bValue
3) create a macro naming it the reserved word AutoKeys
a)create a macrogroup named AutoKeys. Choose what key combination to use to set the bypass key to true and enter those keys as the macro name. (insert, delete and function keys are surrounded by curly braces)
b) choose RunCode from Action list. Enter "setBypassProperty(true)" as the function name in the macro pane.
c) On the next line of the macrogroup, enter the key combination to turn off the bypass key under macro name. Enter "RunCode" under Action and finally "SetBypassproperty(false)" on the Function Name to all your function.
It allows you to open the db, then use the key combination chosen to override the bypass key. When you close and re-log in, the shift key will not bypass. TO enable the shift key, open the database, depress the keys selected to enable bypass, then exit the db. Your shift key should bypass.