J
Just Muddling Through
I have built a fairly simple Access 2003 report with a main report and a
couple of subreports. In the events for the main report's detail I check to
see if two of the subreports have data using the hasData() function and based
on the result turn the label on the subreport visible or invisible, e.g.,
Me!lblIssues.Visible = Not Report_sbrIssues.HasData. When I view the report
in print preview mode everything renders correctly. When I directly print
using the following code snippet the report without first previewing
everything render correctly: Application.DoCmd.OpenReport "rptStatus",
acViewNormal, , , acHidden However I did find in my testing the I must
include the constant acHidden to achieve the correct results.
It is when I print the report after previewing the first few pages the
report does not render to the printed page correctly. It rather seems as
though the events Format, Print, Retreat do not fire in this case. Is there a
fix for this problem? Most of my users are accustom to previewing before
printing.
couple of subreports. In the events for the main report's detail I check to
see if two of the subreports have data using the hasData() function and based
on the result turn the label on the subreport visible or invisible, e.g.,
Me!lblIssues.Visible = Not Report_sbrIssues.HasData. When I view the report
in print preview mode everything renders correctly. When I directly print
using the following code snippet the report without first previewing
everything render correctly: Application.DoCmd.OpenReport "rptStatus",
acViewNormal, , , acHidden However I did find in my testing the I must
include the constant acHidden to achieve the correct results.
It is when I print the report after previewing the first few pages the
report does not render to the printed page correctly. It rather seems as
though the events Format, Print, Retreat do not fire in this case. Is there a
fix for this problem? Most of my users are accustom to previewing before
printing.