Print Preview != Report View

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.
 
M

MarianneZ

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.
 
M

MarianneZ

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?
 

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
How do I open my report in print preview mode in Access? 3
Is this possible from Print Preview? 1
Print a report without displaying print preview 1
Access Access Report Works on One Machine but not Another 3
Running Sum Overall and different views 2
Print Preview issue 2
Print Preview prints form not report 2

Top