Custom Right Click Menu Paramaters

[sheusz]

I have built a custom right click menu that works great. However some users of the DB do not intuitively understand the difference in the print icons. The first print icon opens the print dialog box, whereas the second print icon (with the green tick) does an immediate print (which can be a disaster in a 200 page report, if they just wanted to print the current page). I'd like to change the text next to the icons to something more meaningful to make the commands clearer for the user.

Is this possible using the code I have below or do I need a different approach?

    ' build new right click print menu
    Dim NewRightClickPrintMenu As Object
    On Error Resume Next
    CommandBars("NewRightClickPrintMenu").Delete
    Set NewRightClickPrintMenu = CommandBars.Add("MyRightClickPrintMenu", 5, False, True)
    NewRightClickPrintMenu.Controls.Add 1, 247, , , True 'page setup"
    NewRightClickPrintMenu.Controls.Add 1, 15948, , , True 'print dialogue
    NewRightClickPrintMenu.Controls.Add 1, 109, , , True ' print preview
    NewRightClickPrintMenu.Controls.Add 1, 2521, , , True 'quick print
    NewRightClickPrintMenu.Controls.Add 1, 12499, , , True ' PDF
    NewRightClickPrintMenu.Controls.Add 1, 923, , , True ' close

I have found this reference online, but it seems far more cumbersome.

https://docs.microsoft.com/en-us/off...trol-or-report

[isladogs]

Why not remove the Quick Print item ...or just use the Print Preview ribbon?

[CJ_London]

since you are using the standard functionality, I don't believe you can change 'print' to 'print to printer' or 'send to printer' or similar
similarly I don't think you can include a msgbox before printing along the lines of 'Are you sure you want to send this report to the printer?'
So third option is remove it completely so user has to preview before printing.

Otherwise you need to create your own control - see this link for how this can be done
https://nolongerset.com/right-click-menus-in-access/

[sheusz]

Thanks Ajax and Colin for your input. I think that I'll go with creating my own control. I thought about removing the Print item, but some users like it, and believe it or not, some users get confused by the ribbon when it pops up.

Lots of users with different levels of aptitude.