How to show the ribbon only when a report is opend print preview in access accdr format evenif the ribbon is minimized by someone. Is there any code to ensure the ribbon when a report is opened.
How to show the ribbon only when a report is opend print preview in access accdr format evenif the ribbon is minimized by someone. Is there any code to ensure the ribbon when a report is opened.
Then to hide again, in the report close event:Code:DoCmd.ShowToolbar "Ribbon", acToolbarYes DoCmd.OpenReport strDoc, acViewPreview
Code:DoCmd.ShowToolbar "Ribbon", acToolbarNo
Works with accdb, not sure about accdr
Last edited by davegri; 07-29-2018 at 08:04 AM. Reason: more info
.accdr does not provide a ribbon (nor right click options), if you want ribbon features, you need to create your own.
Thank you for the reply. I want to prevent minimize of ribbon. Do you have any code to ensure a maximized ribbon in print preview of reports.
Last edited by sanal; 07-29-2018 at 11:05 PM.
Thank you for reply.
In print preview of reports toolbar is seen in accdr .
Thank you Ajax. In print preview of reports toolbar is there in accdr.