Print Preview != Report View

  • Thread starter Thread starter MarianneZ
  • Start date Start date
M

MarianneZ

In Access 2007 I've perfected a relatively simple report, viewing it in
report view. It opens a form to get the report criteria, then closes the
form. All this works great in Report View. So I switched it to Print Preview.
In that mode, the form doesn't go away and the report is blank. I tried to
get print preview from Report View. If I rightclick and select Print Preview
or click the Print Preview icon at the botton , I still see the form and no
report at all. Plus as I try various options, it crashes Access.
 
So, your report uses what's in the form you created to know what to display.

Then you close the form?!

How will the report know what to use?

(keep the form open until your report is completely finished)

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
I make the form not visible, grab the report criteria and store them in local
variables (in Vba code), then close the form. I use the local variables to
apply a filter to the report.

I should have said that I started out with the report's Default View
property as Report View. Then after it looked right in Report View, I changed
the Default View to Print Preview. Which didn't work.
 
I've found another instance where a report in Print Preview mode acts
differently than in Report View mode. I have a report with a subreport. This
subreport doesn't always appear. If I don't want the subreport to show, I set
it invisible in the main report's load procedure. When the subreport opens in
Report View mode, I check (in a Report_Open Vba procedure) if the subreport
is visible. If not, I cancel the (sub)report. Works fine. If I do this in
Print Preview mode, I get an error whern I try to set the subreport not
visible in the main report. The error(2101) says "The setting you entered is
not valid for this property." Does that me I can't use Visible in a printed
report?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form, instead of Report, Prints ??? 0
Print a report without displaying print preview 1
How do I open my report in print preview mode in Access? 3
Access Access Report Works on One Machine but not Another 3
Is this possible from Print Preview? 1
Printing a report defaulted to Print Preview crashes Access 2007 7
Print 5
Running Sum Overall and different views 2

Back
Top