How combine Fn button within SendKeys function's syntax (DBA)

[NeedSomeHelp]

Previously, I got help to combine functional keys with Fn button when these keys do not work for MS Access. This button is on my computer.

It helped.
Now, when i need to zoom any field data on the form, I press on three buttons together : SHIFT , Fn, F2.

Usually, I need to use this combination from VBA code (SendKeys function) ,to cause zoom data opening popup window when focus falls on some field of a form.

The syntax was "sendkeys "^{F2}". Now, I don't success to generate syntax including all three parameters.

Please, help me, to generate appropiate syntax for sendkeys function.

Thanks a lot for your time and help.

[Micron]

Are you also using a mouse or only keyboard for some reason? SendKeys is unreliable. If you can, open the zoom form with a double click on a form control instead.

EDIT - or see the chart and examples here
https://learn.microsoft.com/en-us/of...keys-statement

[moke123]

google "acCmdZoomBox" or "access vba zoombox"

[NeedSomeHelp]

Thanks for your reply!

I put SendKey function under event procedure for On Got Focus option of Text Box control.

By my assumption ,this should happen every time when the user reaches this Text Box control, even if he uses a mouse or a keybord.

[moke123]

As Micron has already pointed out sendkeys is unreliable.

set focus to the control and run

DoCmd.RunCommand acCmdZoomBox

[NeedSomeHelp]

Yes! It works!

Thanks both of You for Your quick and helpful advices !

I put this command instead of sendkeys and it works !

Thanks all others for their attention and replys !

Have a nice day !

[Micron]

You really want the zoom whenever the control is entered regardless of what's going on? Seems like that would be a nuisance. Well, if you (or whoever's using the db) is happy then who am I to criticize? Glad we could help.

[moke123]

I'm with Micron on the double-click event. I'd also add a tool tip text of "Double-Click to Zoom"
It'll drive a user crazy clicking the close button while tabbing through a form.