Accelerator Shortcuts

[oskar]

Does Access 2010 has shortcut key property for any control similar to VBA’s Accelerator property (assign a letter and use Alt+Letter to access the command thru the keyboard)

If yes where is this property?

 

[vbaInet]

It's not a property per se, you just prefix the letter with &.

Perhaps this link will provide some insight:

http://stackoverflow.com/questions/...d-shortcut-to-a-button-in-an-access-2007-form

 

[oskar]

Sorry, I forgot to ask; how do we do the same for the Navigation Buttons (First Record, Last Recrd, Previous & Next)?

I'm using Access symbols for these 4 buttons and I have left the Caption Property
unchanged

 

[vbaInet]

Unfortunately, you can't alter the navigation buttons. If you want that look and feel you will need to roll out your own navigation controls.

 

[oskar]

Somehow I thought so, what I got will suffice for now because they are cute.
Much appreciated

 

[vbaInet]

No problemo!

 

[vbaInet]

Now that I've seen your form in your new thread, were you talking about those buttons? I thought you were referring to the navigation buttons that come with a form.

In any case, with the buttons that you currently have on your form, you can enter the value into the Caption property and set the Picture Caption Property to an appropriate value.

 

[oskar]

Not sure if understand right, so I could put into the Caption property lets say &Next but in the Picture Caption Arrangement the options are General, Top, Bottom etc. so if I select any would that remove the cute arrow?

 

[vbaInet]

Try it and see if the cute arrow would still remain

That's how you learn.

 

[oskar]

lol, I was afraid you will say that cause Idont want to mesh around with the form, but will make a copy of the dB and will see the results there

 

[vbaInet]

Just make a copy of the button and give it a try, and hopefully that lovely arrow stays put.

 

[oskar]

Unless I do something wrong it does not work. I change the Caption of the Next Record button from Command48 to &Next and the Picture Caption arrangement from No Picture Caption to General and the button does not work plus I loose the picture and I see &Next (I also tried &N with same results).

 

[vbaInet]

You must have deleted the value in the Picture property and unlinked the code. Create a new button and change only those two properties.

 

[oskar]

The picture caption property has these values: No picture caption, General, Top, Bottom, Left, Right. To my opinion if I change this property to anything else than No picture caption, the icon on the button will disappear. I tried all above and that's what I see. But of curse I can be wrong

 

[vbaInet]

I see. What version of Access are you using? It might be so in much older versions.

 

[oskar]

Access 2010

 

[vbaInet]

That's what I've got installed on this laptop and it behaves like I explained. Go to the Picture property, click the ellipsis button and re-select the image.

 

[oskar]

Sorry, now it works BUT the new arrow is not as cute, lol. So it's a choice I have to make either a cute arrow and no keyboard shortcut or a arrow with keyboard shortcut. Choices are good to have

 

[vbaInet]

The cute arrow that was created when you first drew the button is also listed in the Picture property, it's just a matter of finding it. If you show me a screenshot of the differences I will tell you which image it is.

 

[oskar]

Here is the picture