problem excel 2013 print preview show margins

To remove these dotted lines, select a cell in a row that immediately follows the primary page break.In newer versions of Excel, the manually-added page breaks are presented as solid lines, whereas automatic page breaks are displayed as dotted lines. When you’ve formatted your spreadsheet for print, page breaks are shown as lines. Strange dotted lines might also be due to a page break. To do so, select the View tab at the top and then uncheck the box next to Gridlines.It should work with the exceptions mentioned above.Įven though this thread is somewhat past maybe someone can pick it up and explain a little more. or you can turn them off if you want.Ĩ) Close db open in user mode. It's oKay if the default and full are checked because you set the Start From Scratch = Yes in the Code. Or you can add the filter tabĥ) Go to Table's datasheet view and add the following to Record 1ħ) Access Options, Current db, Under Ribbon and Toolbar options, RibbonName, select MyReports. However if you get the current record only on the Form before you output then it will output only the current record. but a work around could be to add a button to Close the Report.ģ) using the output to pdf from the Ribbon will output all records if you filtered to the current record. Can be authored only in start from scratch mode.Ģ) There is an issue when using only the Reports Ribbon in the following, where the Close Print Preview Button does not function. Anyone know what Nick can add to cover the Quick Access ToolBar being visible?Īfter researching this more I have come to understand a few things.ġ) The Quick Access Toolbar (QAT) can only be removed from the Ribbon. While this does work, There needs something more to hide the Quick Tool Bar because it shows up on mine and then I can add many commands including Design Mode. Private Sub Report_Open(Cancel As Integer) Then on the Report code you will need these three codes Option Compare Database You will want your ribbon = no code on the Form Private Sub Form_Load()Īlso on the Form you would want your code to open the Report Private Sub btmOpenreport_Click()ĭoCmd.OpenReport 'rptSample', acViewPreview

I used the code in my db and it does work. Functions can be created to cover multiple reports.

I just used the download from Gunther site #31.

Problem excel 2013 print preview show margins