Printer object bug with Access 2003 - confirmed by Microsoft Corporation

[ellipsys]

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

[Allen Browne]

Thanks for posting.

The bug seems to be triggered by this line of code:
Printer.BottomMargin = 5

It crashes Access with a dialog titled:
Microsoft Visual C++ Runtime Library
The dialog message reads:
Runtime Error!
Program: C:\Program Files\...\MSACCESS.EXE

This application has requested the Runtime to terminate in an unusal
way.
Please contact the application's support team for more information.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<el******@virgilio.it> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

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