From: Peter Hibbs on 22 Apr 2010 04:19
Glad to be of help. Just one other point since this facility is new to
you. If you actually want to include the ampersand character in a
label like 'Fish & Chips' for example, you need to double up the
ampersand so that it becomes 'Fish && Chips'.
Also, with regards to the check boxes, your users may or may not know
that if a Check box has the focus you can just press the SPACE BAR to
toggle the Check box.
On Wed, 21 Apr 2010 23:37:01 -0700, Rose B
>Peter, as ever.... you are BRILLIANT!!! I had looked at just about every
>property of the form and of the checkbox.... but hadn't thought of looking at
>the label! Never come across this before - another one for my tool box.
>"Peter Hibbs" wrote:
>> I believe you are describing the built-in short cut facilities of
>> Access (and every other Windows program for that matter) where the ALT
>> key can be used as a short-cut operation.
>> To create a short cut for a control (usually a button) you just
>> precede the relevant letter in the label with the ampersand character.
>> So if you have a button (or Check box) which has the caption (or
>> attached label) showing as, say, Print, if you insert the ampersand
>> character before the caption text so that it now shows &Print the
>> letter P will be underlined and when the user presses ALT + P the code
>> attached to the button will be executed.
>> If your extra Check box has a label you can just insert the ampersand
>> before a letter in the label (that has not been used elsewhere on the
>> form) and then pressing the ALT key plus the letter will toggle the
>> Check box.
>> Does that fix the problem?
>> Peter Hibbs.
>> On Wed, 21 Apr 2010 12:00:01 -0700, Rose B
>> <RoseB(a)discussions.microsoft.com> wrote:
>> >mdb - I have full access to the design of the form, and have also searched
>> >through the VBA code
>> >"Beetle" wrote:
>> >> If you look at the file extension for the application in question,
>> >> is it .mdb or .mde?
>> >> --
>> >> _________
>> >> Sean Bailey
>> >> "Rose B" wrote:
>> >> > I have an Access application that was written by someone else (in Access
>> >> > 2003) which has a form with various checkboxes on. The checkboxes can be set
>> >> > to true/false by using some shortcuts - for example Alt + P. The user wants a
>> >> > new checkbox to be added, with a new shortcut to toggle the setting. The
>> >> > problem I have is that I cannot see how the shortcut actions have been done!
>> >> > I can find no customised ribbons, VBA attached to the form and/or controls on
>> >> > the form, macros etc. etc.
>> >> >
>> >> > Can anyone help????