rwwilliamson
New User
- Local time
- Today, 10:33
- Joined
- May 26, 2005
- Messages
- 11
I'm attempting to create a form that has a checkbox in addition to some numeric entry fields. The checkbox is True/False and it is a tab stop on the form.
1. Is there a keystroke that can change from True to False (check/uncheck), or is a mouse click required? This form will be used extensively to update some records and a keystroke would be handy instead of having to move from the keyboard to click a mouse button.
2. After update, if the checkbox is True, then a numeric adjustment must be made to a calculated value. If False, then do nothing. Does a checkbox have a numeric value that can be used in an equation? Name of the checkbox is "Option".
These seem fundamental needs, but not obvious to me from using Access Help.
Later on in the same evening . . .
Oh, never mind. Of course "Space Bar" toggles checkboxes. And I discovered by just writing the equation that True = -1 and False = 0. So the name "Option" can be used in an equation just like any other number. Too obvious.
1. Is there a keystroke that can change from True to False (check/uncheck), or is a mouse click required? This form will be used extensively to update some records and a keystroke would be handy instead of having to move from the keyboard to click a mouse button.
2. After update, if the checkbox is True, then a numeric adjustment must be made to a calculated value. If False, then do nothing. Does a checkbox have a numeric value that can be used in an equation? Name of the checkbox is "Option".
These seem fundamental needs, but not obvious to me from using Access Help.
Later on in the same evening . . .
Oh, never mind. Of course "Space Bar" toggles checkboxes. And I discovered by just writing the equation that True = -1 and False = 0. So the name "Option" can be used in an equation just like any other number. Too obvious.
Last edited:
