My problem is that despite setting various reports to Landscape the settings keep reverting to Portrait when next opened in Print Preview (possibly because I have 3 different printers connected) - ie the setting is not saved with the report. As I use a macro to open the report in preview, and in the macro put a SendKeys action (%VZF)to size to fit screen how can I add an action to change page setup to Landscape (Send keys will only go as far as opening dialog box) A homemade Function would seem to be the answer. Can anyone help with this please. Many thanks.