Report will not open in print preview view

[mimottershaw]

Hi there,

I've used this forum successfully in the past, so hopefully you will be just as helpful again. I am trying to produce a report that takes its data from a query, and filters by way of another form with unbound text boxes for inputting report criteria. When the report is produced it will not open in print preview view, in spite of having the default view property set to print preview. I found a Microsoft work around article, which involved adding a module. I tried this with little or no (NO) success!

I can't believe there isn't an easier way round this, and hoped someone would know it!

Thanks in advance.

Mark

 

[Exodus]

What code are you sing to open the report?

DoCmd.OpenReport "your report", acViewPreview

 

[mimottershaw]

Thank you Exodus

What code are you sing to open the report?

DoCmd.OpenReport "your report", acViewPreview

You got me thinking! I realised that there was probably code hidden in menu button items in my switchboard. It turns out that this code was forcing the report to open in report view and not print preview. I changed this and it now works. Thanks for the push in the right direction

Mark