Prevent Print Preview Ribbon activating?

[DubCap01]

Hi all,

I know it's primarily a report question, but so many more eyes here. I am trying to disable the print preview ribbon from dropping down when I preview any report in A2010.

I have tried this calling this function option in 'Current', 'Activate', and 'Open', and whilst it works perfectly for forms, it just won't prevent the Preview Ribbon for reports!
option:

If Not CommandBars.GetPressedMso("MinimizeRibbon") Then
CommandBars.ExecuteMso "MinimizeRibbon"
End If

It is important that the report opens into Print Preview mode, as some users may wish to save a tree frog by not printing a large report...


Any clues anyone?

cheers
Pete

[June7]

You want to eliminate any print option? Are you going to also disable the right click shortcut menu?

I've never used CommandBars method. I do have code that customizes the ribbon and reference custom ribbon in report RibbonName property. I also disable shortcut menu in database options.

Are reports set to default open to Print Preview? And also use PrintPreview parameter in DoCmd.OpenReport method.

[DubCap01]

Hi June7 - sorry for not responding sooner, been away - illness.

It's a MSAccess2013 thing... It works exactly as planned in MS Access 2010! In A2010, the Menu bar minimizes; users can still print via right-click, or by clicking File (and then the Menu Bar reappears) - Print, or via the Quick Print option on the Quick Access Toolbar Ribbon.

BUT in A2013 the Full Menu Bar appears regardless!

cheers
Pete

[June7]

I don't know Access 2013 well enough - yet, but perhaps will have to do ribbon customization.

[DubCap01]

Hi June,
Found the easy way to hide the Print Preview Ribbon - and it has nothing to do with the report design or anything!
I went into File - Options - Customize Ribbons and clicked off 'Print Preview'
Job fixed! Users still have the right-click 'Print' and File - Print options should they wish to do so...

cheers
Pete

[June7]

That setting holds for any database you open. It is not database specific - it is an Access application setting.