Intrinsic constants as bit masks
Applies to: Access 2013 | Access 2016
To test for the Button or Shift arguments, use a bit mask.
The Button argument is a bit field with bits corresponding to the left mouse button (bit 0), right mouse button (bit 1), and middle mouse button (bit 2). These bits correspond to the values 1, 2, and 4, respectively. Only one of the bits is set, indicating which button triggered the event.
The intrinsic constants that Microsoft Access provides for the Button argument have the following values.
| Constant | Value |
|---|---|
| acLeftButton | 1 |
| acRightButton | 2 |
| acMiddleButton | 4 |
The Shift argument is a bit field, with the least significant bits corresponding to the SHIFT key (bit 0), the CTRL key (bit 1), and the ALT key (bit 2 ). These bits correspond to the values 1, 2, and 4, respectively. The Shift argument indicates the state of these keys. Some, all, or none of the bits can be set, indicating that some, all, or none of the keys is pressed. For example, if both CTRL and ALT were pressed, the value of the Shift argument would be 6.
The intrinsic constants that Microsoft Access provides for the Shift argument have the following values.
| Constant | Value |
|---|---|
| acShiftMask | 1 |
| acCtrlMask | 2 |
| acAltMask | 4 |
Use the constants to test for any combination of buttons and keys without having to figure out the unique bit field value for each combination. A bit is set if the button or key is pressed.
See also
- Access for developers forum
- Access help on support.office.com
- Access help on answers.microsoft.com
- Access forums on UtterAccess
- Access developer and VBA programming help center (FMS)
- Access posts on StackOverflow
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.