Hi folks,
I have modified my various Access databases to use a custom ribbon instead of the old-fashioned Switchboard form.
I've gotten most everything to work, but there is a quirk:
When I open a report in print preview mode, usually the Print Preview ribbon tab appears so it's easy to close the preview, export to Excel, etc.
But sometimes that tab does not activate, and my custom ribbon tab stays active. When this happens, the Print Preview tab is there, just not activated, and I need to train my users to click that tab to open it.
I thought I could put code in my application to activate that tab:This may or may not work, and I instead may have to put the first command in the Report_Open event of each report.Code:gRibbon.ActivateTab "myPrintPreviewTabID" DoCmd.OpenReport .......
Either way, I need to know the ID of the Print Preview ribbon tab. I've googled around and can't seem to find it.
Any ideas? Thanks...