- Open Access 2003
- Create new database (2000 or 2002/2003 format)
- Create a report and insert a label in its Detail section
- Save the report as Report1
- Copy Report1 as Report2
- Open Report1 and insert Report2 in it as subreport
- Save Report1
- Create a form and use the wizard to insert a button which can open
Report1 for preview
- Go to VBE and navigate to the Click event of the button
- Change the following two lines
stDocName = "Report1"
DoCmd.OpenReport stDocName, acPreview
with this four lines
stDocName = "Report1"
Printer.PrintQuality = acPRPQMedium
DoCmd.OpenReport stDocName, acPreview
Printer.BottomMargin = 5
- Save form as Form1
- Open the form normally
- Click the button
- Here is the bug
I contacted Microsoft Italia (beacause I live in Italy). They informed
Microsoft Corporation which replied confirming it's a bug for Access
2003 and will be corrected in the future. They didn't tell if the
problem will be corrected with a specific patch or with Service Pack 2
for Office 2003.
You will not find any documentation in internet (neither in Microsoft
web site nor in MSDN nor elsewhere) until a correction will be
developed.
I hope this could help.