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.
 
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?
 
Back
Top