Show/Hide Design Tools
acCmdViewToolbox, acCmdFieldList, acCmdProperties, acCmdSortingAndGrouping, acCmdViewRuler
Another piece of code that is probably not very useful.
Displays the various dialogs that can be used in the design of a report. If any are already in view then it hides them. The selet object line is necessary as the Properties box rather than the report has the focus.
'***************** Code Start *******************
'Code by Terry Wickenden
Sub ShowDesignTools(strReport as String)
DoCmd.OpenReport strReport, acViewDesign
DoCmd.RunCommand acCmdViewToolbox
DoCmd.RunCommand acCmdFieldList
DoCmd.RunCommand acCmdProperties
DoCmd.SelectObject acReport, strReport, False
DoCmd.RunCommand acCmdViewRuler
DoCmd.RunCommand acCmdSortingAndGrouping
End Sub
'****************** Code End ********************